Q&A BY TAG 'cache'

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

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Answers: 5

Query Full Cache WHERE CONDITIONS Cache

Denodo Cached Base View Issue: returns 0 records in left join
answered 23-09-2019 08:11:59 -0400

Nevermind! Figure out the issue.

Answers: 1

Base view Query Cache

Cache Database with mysql(AWS Aurora)
answered 03-09-2019 08:07:21 -0400

The customer wants to use the mysql(AWS Aurora) for Dev and QA environment. Is preferable to mysql as cache database in respective to performance? Customer Source system is oracle and MS SQL Server. Based on the caching requirement, they are plann...

Answers: 1

cache

Listing views with cache enabled
answered 22-07-2019 01:43:59 -0400

How can I get a list of views where cache has been enabled?

Answers: 1

cache view option cached views

Partial cached data subset still going to source
answered 14-05-2019 18:48:27 -0400

We are currently trying to use partial cache in denodo in both the versions of 6 & 7 and facing one issue. When we put the partial cache on for the view and run the query to cache it. For eg. Select * from test1 where id in (1,2,3,4); it caches ...

Answers: 1

Partial cache Cache

Schema change and Source Refresh with Denodo and Cache store
answered 24-04-2019 17:23:09 -0400

Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...

Answers: 1

Source refresh schema change Cache Cache error

Why is it recommended that Apache Derby embedded database should NOT be used for storing cache data for production?
answered 15-04-2019 14:17:44 -0400

For almost all of the Denodo articles that talk about caching, we see snippets like this: "... you can configure the cache module to store the cache data in the Apache Derby database embedded in Virtual DataPort. However, we strongly recommend using an...

Answers: 1

Cache

Cache Error Modifying View
answered 05-03-2019 06:48:57 -0500

Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...

Answers: 2

Cache

SSRS and Caching
answered 27-02-2019 05:02:03 -0500

I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected. It seems as if the report is ...

Answers: 1

cache partial cache ssrs

Cache modes
answered 07-01-2019 17:56:38 -0500

Hi, I'm using the Denodo Express Edition platform and I'm trying to try the partial cache mode with the Match exact queries only option. I have entered Administration> Server configuration and I have activated Cache Status. Then before executing the...

Answers: 1

Partial cache Cache