Latest Activity
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
Hi, Can you assist me with any documents with info on cache table indexes
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 Virtu...
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. INVOLVED TABLES -------------------------- Customers table is static. Orders table is incremental. VIEW DEFINITION ----------------- CREATE VIEW customers_j_orders AS SELECT customer...
In trying to activate the cache for a base view which was created from a query, it throws up an error dialog in either trying to activate partial or full cache on the base view. Error for partial cache activation is: "error modifying view: An SQL data...
Created a base view which has custom sql to create it that comes back with two text columns. Both vase view and original database have those columns set as varchar(1024). When executing the base view with cache invalidate it returns rows back. When ...