Content
Virtual DataPort incorporates a cache module that stores local copies of the data retrieved from the data sources in a relational database.
The cache can be used to reduce the impact of queries hitting the data sources and to speed up their executions, especially for sources whose performance is slow or overloaded.
By default, the cache module will store the cached data in the Apache Derby database embedded in Virtual DataPort.
This default configuration can be used for testing or for small data sets but it is not recommended for large data sets or on production environments. It is strongly recommended to use any of the external Database Management Systems available for the cache system, especially in production environments.
References
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
