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 10-03-2020 00:44:36 -0400

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: 3

Cache

Denodo cache storing at external DB
answered 09-03-2020 12:04:09 -0400

Please I want to ask if I can store denodo cache at external database ( as mysql or other) ?

Answers: 1

external Database Cache

SQLServer as Cache with BCP - Best practices ?
answered 05-03-2020 07:28:52 -0500

Hello, When switching from MSSQL "standard" cache load, to a bulk-load using BCP, what are the best practices and recommendations regarding the SQL Server database ? The User Manuals (here) are quite laconic about that. Best regards

Answers: 3

MSSQL bcp 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 deployment 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