Hello. I work with a cache for views. And faced with strange behavior. When I am disabled the cache for a view, the execution time amounted ~50ms. When I am enabled partial cache, the execution time amounted ~400ms.
I need opportunities for fetching p...
I found when joining to a cached view performance is slow probably due to network latency, I decided to move the cache into my EDW to see if performance would improve. It did marginally but Denodo didn't recognize that the Cache and the data I was join...
Hi, When i open the cache database in SQL , i see lot of Heap tables where there is no index created. Can i go ahead and create clustered indexes on that.. Will that help us to improve cache load performance
search in index
Would like to find out if we can create multiple Cache databases within one Denodo server:
Admin, Virtual Database1, Virtual Database2, Virtual Database4: uses a MySQL Cache database DB1
Virtual Database3: uses a MySQL Cache database DB2
How can we Incremental reresh the cache when in SQL source we dont have created or updated timestamps, to be used in where clause.
Hi there, Does Denodo support a shared cache data source, from a common cache RDS? We have multiple production nodes and I would like them to all hit the same cache if possible.. IE.. we can just run the schduler on one node to populate the cache each ...
CALL CLEAN_CACHE_DATABASE is cleaning whole database cache. is there any way/function to clean cache of specific views/folders and not whole database using Scheduler?
If I want to clean cache of specific views and not whole database, is it possible? If yes, how? Can I clean cache of all views in specific folder? If yes, how?
Being new to Denodo , need help to implement the below situation.
Customers table is static.
Orders table is incremental.
CREATE VIEW customers_j_orders AS