Use virtualdac as "local cache" for ODAC Tables

[amoroder]

Hello,

we are very happy with ODAC, but we have problems with the latency of our Network ( 50 km fiber ).
We would like to load the records from a few configuration tables to Virtualdac via ODAC and the execute the queries on the virtual tables.
Is this supported by virtualdac?
Are there some limitation on the complexity of the queries?

Thank you very much
Andreas

[MaximG]

Thank you for the interest to our products. You can implement the behavior you are interested in with VirtualDAC using the VirtualTable and VirtualQuery components included in it. The VirtualTable component is designed to store data in memory. With it, you can load the Oracle tables you are interested in to the memory, and then connect the obtained VirtualTables as data sources of the VirtualQuery component. Using it you can execute complex SQL queries to the connected tables. To become familiar with our product, you can use the full-featured trial version, available at: https://www.devart.com/virtualdac/download.html