Q&A BY TAG 'Cache'

You must sign in to ask a question. If you do not have an account, you can register here

Fetch plan of the query cache
answered 01-03-2017 06:59:24 -0500

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

Answers: 3

execution plan cache

Joining to Cache
answered 24-01-2017 23:23:28 -0500

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

Answers: 1

cache

Index on cache table created in MSSQL
answered 09-01-2017 11:37:33 -0500

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

Answers: 1

cache search in index

Info on cache table index
answered 03-01-2017 04:09:32 -0500

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

Answers: 1

cache search in index

Multiple Cache databases in one Denodo Server
answered 18-11-2016 20:55:11 -0500

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

Answers: 1

cache

Incremental refresh of cache
answered 20-10-2016 16:04:24 -0400

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

Answers: 3

cache performance caching

Shared Cache
answered 07-10-2016 02:32:42 -0400

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

Answers: 1

cache

Looking for cleaning cache of specific views/folders and not whole database Using Scheduler.
answered 09-09-2016 06:51:38 -0400

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?

Answers: 2

data cleansing cache

How to clean cache for specific views/folder
answered 09-09-2016 06:02:34 -0400

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?

Answers: 5

data cleansing cache

Need help on incremental caching
answered 28-08-2015 08:24:29 -0400

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

Answers: 3

cache