Using Apache Derby as cache
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
Questions
Ask a question
You must sign in to ask a question.
If you do not have an account, you can register here
Featured content
DENODO TRAINING
Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.
