Latest Activity
When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Similar q...
For the VQL statement to cache view1 below, if this query is executed in a query window and the checkbox to "Retrieve all rows" is not selected, the query will cache only the number of records listed in "Limit displayed rows:" SELECT * FROM view1 CONT...
Hi Denodo Community, One Question from the new guy here :-) After Changing a Base View with "Source Refresh" the Cache Table is new generated. After that the Cache Table is empty. Now i have to remember to fill the Cache Table with "Starting the Sche...
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!? (runt...
I want to enable cache, but I am curious to know which one is best for use from SQL Server and Netezza? Can you provide a comparison sheet or you can help me to understand between them as which is one benificial to use?
For almost all of the Denodo articles that talk about caching, we see snippets like this: "... you can configure the cache module to store the cache data in the Apache Derby database embedded in Virtual DataPort. However, we strongly recommend using an...
The Denodo Platform cache can be used to for what do we use the denodo platform cache ? and why do we cache data ? is it for avoiding running the same queries again or whaen the data is geographically distributed?
Hello, We have a VDB with cache db configured on Azure PostgreSQL v11. Assume a scenario when a SELECT is already running on Denodo VDB, accessing data from the configured cache. Now, if the Cache refresh job starts, at a set time, through Denodo Sched...
Hi, Is there a VQL query I can run as a developer in Denodo to determine the time to live of cached views? I have tried the following queries but it seems to only indicate whether the item is cached or not. select from catalog_views() where resultcac...
in denodo scheduler the cache jobs are stuck running state