Q&A BY TAG 'cache'

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

Caching not working while joining two tables.
answered 09-05-2017 08:00:40 -0400

Hi, I have created two tables X, Y and enables the cache. With the current configuration. X, Y caching works individually. But when I do a join query with both tables. The cache is not working. Can some one help me on this. EX: select from X trace; -...

Answers: 1

cache cache configuration Cache error

Teradata as Cache Database and Configuring Monitoring Tool for Teradata
answered 24-04-2017 16:56:47 -0400

Teradata as cache Database: Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should w...

Answers: 2

cache Denodo Monitor cache configuration teradata monitoring tool monitor

Test file to check if cached view is not empty
answered 16-03-2017 08:22:49 -0400

Hi, I want to create a test files to see if the cached views are empty.Initialy i thought of just selecting top 100 records from cached view in %Execution directory and another query selecting top 100 directly from source in %result directive. But late...

Answers: 5

cache Denodo Testing Tool cache configuration

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