You can translate the question and the replies:

Partial Cache- Explicit loads

Denodo 6.0 express edition Created a derived view coming from a soap web service and a mysql database. Enabled cache at the server level. Enabled partial cache with explicit loads for the derived view. I executed the query "Select * from derived_view_name where condition" Execution trace shows: records fetched from data source executed "Select * from derived_view_name where condition CONTEXT('cache_preload' = 'true') query the data source executed "Select * from derived_view_name where condition, again fetches the records from data source. Where am I going wrong?
17-07-2017 19:49:01 -0400

1 Answer

Hi, I tried the same and it worked for me. The issue might be because the cache database might not be fully loaded with the resultset. Please follow the below steps. 1. Create a derived view. 2. Enable partial cache and select the explicit load option. 3. Execute the view with Context clause with the following parameters in the context clause: * ‘cache_preload’ = ‘true’ * 'cache_wait_for_load'='true' Keep in mind that the parameter 'cache_wait_for_load' = 'true' to the CONTEXT clause forces the query to wait until all the results have been stored in the cache database. If your query returns a lot of information and you execute it again before all rows are inserted in the cache, the query will return the data from the data sources instead of from the cache. To know more about the partial mode of cache read the section [“Partial Mode“]( and [“Recommended Parameters for Queries that Load the Cache”]( of the Virtual DataPort Administration Guide. Hope this helps.
Denodo Team
19-07-2017 07:45:26 -0400
You must sign in to add an answer. If you do not have an account, you can register here