Latest Activity

code

Fetch plan of the query cache

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...

execution plan cache

code

Joining to Cache

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...

cache

code

Index on cache table created in MSSQL

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

cache search in index

code

Info on cache table index

Hi, Can you assist me with any documents with info on cache table indexes

cache search in index

code

Multiple Cache databases in one Denodo Server

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...

cache

code

Incremental refresh of cache

How can we Incremental reresh the cache when in SQL source we dont have created or updated timestamps, to be used in where clause.

cache performance caching

code

Shared Cache

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 ...

cache

code

Looking for cleaning cache of specific views/folders and not whole database Using Scheduler.

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?

data cleansing cache

code

How to clean cache for specific views/folder

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?

data cleansing cache

code

Need help on incremental caching

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...

cache