Latest Activity
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
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...
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...
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 ...
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...
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 ...
Nevermind! Figure out the issue.
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...
How can I get a list of views where cache has been enabled?
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 ...