Q&A BY TAG 'Cache'

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

Cache Refresh Issue
answered 25-02-2020 20:49:27 -0500

Cache DB: Oracle Denodo Version: 7.0 Caching Mode: Full cache Current Setup: There are two prod servers under a load balancer. There is one cache DB that is configured for both the server. Hello, we have a unique situation with the cache DB and sched...

Answers: 2

Cache

Cache Load Question
answered 10-02-2020 07:49:05 -0500

Source Database: DB2 I have a view say top_level_view, which takes a long time to query and aggregate from the DB2 database. We decided to cache this view with a where clause for 15K keyids. To begin with we tried to run the view without caching to se...

Answers: 1

Full Cache Cache

unavailability of shared cache during deployments in mult-node architecture
answered 28-01-2020 11:10:19 -0500

we have a single cache DB ( shared cache) for multiple Prodution denodo nodes. but problem with this architecture is when we do deployment of views having cache associated with it on any of nodes . this makes the cache unavailable/invalid for other nod...

Answers: 1

shared cache Zero downtime Cache deployment

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 09-01-2020 14:37:07 -0500

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 1

Cache

Denodo Disparat sources join without Cache.
answered 26-12-2019 14:12:56 -0500

Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...

Answers: 3

join Cache

Cache fetch error
answered 12-12-2019 00:34:47 -0500

Hi Team, Denodo 6.0 source DB : SQL Server cache DB : SQL Server cache type : Full Cache , Never Expire normal query : runs successfully, 10230397 rows cache query : when loading cache : error Error: [BASE] [ERROR] There was an error during a batch...

Answers: 4

Cache

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