Use virtualdac as "local cache" for ODAC Tables

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 29
Joined: Sun 12 Sep 2010 11:33

Use virtualdac as "local cache" for ODAC Tables

Post by amoroder » Tue 21 Aug 2018 14:15


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

Devart Team
Posts: 1498
Joined: Mon 06 Jul 2015 11:34

Re: Use virtualdac as "local cache" for ODAC Tables

Post by MaximG » Tue 28 Aug 2018 13:39

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:

Post Reply