Applies to:
Denodo 8.0
,
Denodo 7.0
,
Denodo 6.0
Last modified on: 10 Jun 2020
Tags:
Cache
Optimization
Performance
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 are 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
Virtual DataPort Administration Guide: Configuring Cache
Virtual DataPort Administration Guide: Cache Module