Q&A BY TAG 'caching'

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

How Caching Works with Denodo?
answered 23-06-2022 11:39:24 -0400

Hi, How Denodo Cache the data when fetching it from Data Source? What's the Space it consume while caching? What's the retention period of Cache, when it flushes the Cache? Can we define the data that needs to be fully cache, partial cache or no cach...

Answers: 1

Partial Caching Full Cache caching

one job in scheduler to refresh multiple views
answered 19-11-2021 12:04:46 -0500

Is there a way to have one cache job that refresh multiple views? we have a process that we had to set up 26 separate refresh jobs and I am wondering if there is a better, more efficient way of doing this?

Answers: 1

Automic scheduler custom script caching Cache

Full Caching mode
answered 16-10-2020 07:41:32 -0400

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

Answers: 1

caching

Caching issue while sending data to MYSQL workbench.
answered 16-10-2020 07:03:15 -0400

Hello, I have a problem with caching the data I got an error : Finished with error: Error loading cache: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Loading local data is disabled; this must be enabled on both the client and server sid...

Answers: 1

caching

Centralized Caching Server
answered 14-01-2019 09:09:55 -0500

Hi Denodo Team, I have to achieve scalability with Denodo instances. If i introduce a load balancer and configure multiple denodo instances behind it. Is there a possibility that all the instances write to a single cache server via JDBC? Can i use a...

Answers: 2

caching

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

Caching denodo platform
answered 20-06-2016 05:47:15 -0400

Hi, Can anyone provide a hardware requirements to use oracle as a cache in denodo platform. I want to know how much space it may require and whether it will use hard disk or RAM. and so on.

Answers: 1

caching

deleting cached records
answered 15-10-2014 13:18:34 -0400

How do I physically remove invalidated cached records for a view ? While 'cache_invalidate' = 'true' clause making the logical deletion, what command performs the physical deletion at view level ? Arif Zaman

Answers: 2

caching

implementing caching
answered 13-10-2014 14:03:27 -0400

How do I implement caching using derby database for denodo express ? Caching configuration tab does not have any option to enter derby database details. Arif Zaman

Answers: 1

caching