You can translate the question and the replies:

Partial cache without explicit load

Hi I have a view partially cached without 'Explicit loads' and without 'Match exact queries only' and TTL = 60. In another view, I am calling the former more than once, but the cache is not built and Denodo goes to the data source all the times!? (runtime of the view is <60s) Why is it not building the cache at the first call and using it afterwards? How can this be achieved? Thank you!
user
20-10-2023 02:11:16 -0400
code

1 Answer

Hi, The first time a query over the view is executed, the cache table will be populated with the tuples in the output. At runtime, when a user queries the view, the Denodo server checks if the cache contains the data required to answer the query. If it does not have this data, Denodo will query the data source and populate the cache. Additionally, when the Time To Live (TTL) of the data is reached, the cache system invalidates the cached data of the view so the next query will hit the data source. For your scenario, I would try increasing the TTL and check if this works, that is data is obtained from cache. Please refer to [Partial Mode](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/cache_module/cache_modes/partial_mode) section of the Virtual DataPort Administration Guide for more information. If you are a valid user I recommend raising a new case support case in the [Denodo Support site](https://support.denodo.com/) so that a technical engineer could diagnose your issue specifically in your scenario. Hope this helps!!
Denodo Team
20-10-2023 10:22:10 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here