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

Download document

You can translate the document:

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.

Training