You can translate the question and the replies:

Data Compression in Denodo with caching

Hi, Is there an option to compress the data while caching it in caching DB. We are exploring an option to compress data while caching the data in caching DB and at the same time, data should be uncompressed while retriving data from end application. Regards.
user
07-07-2017 13:11:52 -0400
code

1 Answer

Hi, Since Denodo supports a wide range of databases to be configured as your local Cache DB, I would recommend you to use the database compression for your selected database. In my case I use SQL Server as my Cache DB and I apply row level compression and page compression techniques. It is recommend to use “CLEAN_CACHE_DATABASE” stored procedure before periodically applying the database compression. I would ask you to refer to the section [CLEAN_CACHE_DATABASE](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/clean_cache_database) from Virtual DataPort VQL Guide. Hope this helps you!
Denodo Team
10-07-2017 08:57:58 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here