You can translate the question and the replies:

deleting cached records

How do I physically remove invalidated cached records for a view ? While 'cache_invalidate' = 'true' clause making the logical deletion, what command performs the physical deletion at view level ? Arif Zaman
user
12-10-2014 00:55:25 -0400
code

2 Answers

Hi Arif, Denodo provides a Maintenance Task that deletes invalidate entries from cache. By default, it is launched every 21600 seconds (6 hours). You can disable or change the maintenance period at Administration/Server Configuration/Cache (see section 10.1.3 from the Virtual Port Administration Guide). Also, you can directly execute the following stored procedure from Tools/VQL Shell in order to force the launch of the Cache Maintenance task (see section 11.3.6 from Advanced VQL Guide): CALL CLEAN_CACHE_DATABASE ('databaseName'); Hope this helps. PS: referenced guides can be accessed from: https://community.denodo.com/docs/show/Virtual%20DataPort/Denodo%205.5
Denodo Team
13-10-2014 06:32:20 -0400
code
Thank you for the answer. Am i right in thinking that in order to delete records from cache, the cached records must be invalidated first.
user
15-10-2014 13:18:34 -0400
You must sign in to add an answer. If you do not have an account, you can register here