Q&A BY TAG 'performance'

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

Performance Issues with many Columns, MongoDB source
answered 24-05-2022 09:30:52 -0400

Hello dear Denodo team, I have a question regarding the performance of a view based on a MongoDB data source. The base view in question has about 2.7 million records and 256 columns. Running the query SELECT max(date) FROM ; I tried several things...

Answers: 3

performance optimization mongodb

Isolated query of a joint view
answered 16-04-2021 08:35:01 -0400

Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...

Answers: 1

Denodo 8.0 performance join

Poor performance for jdbc and json array type join
answered 09-10-2020 08:19:14 -0400

Hi, I observered a poor performance for a join between a jdbc type view and json array. individually when queried they are running fast but when we do a join it's performance degrades. Can you suggest how to improve performance ? Also i see 347 subp...

Answers: 1

performance JSON join

Issue in select clause while executing joined tables from teradata and SAP Hana
answered 12-08-2020 08:31:54 -0400

Hi, I have joined tables from teradata and SAP Hana, i was able to execute the view and get data if i add a where clause in the query. but when i run select * from table query it is running for a long time and throws error as 'error in join'. also not...

Answers: 1

#powerBI connection #Denodo-PowerBI performance

Denodo Union / Sort Merge Performance Issue
answered 07-02-2020 18:46:56 -0500

I currently have two derived views, say D1 and D2, that are unioned together to create D3. I originally had an issue with both D1 and D2 which involved a sort merge. Both D1 and D2 are a join of two base views; each ran very well when I had a date fil...

Answers: 1

performance sort merge UNION

Oracle DB enforce parallelism
answered 31-01-2020 01:53:34 -0500

Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually an...

Answers: 1

performance parallel JDBC Oracle DB connection Issue

Performance Bench Marks
answered 10-01-2018 09:27:29 -0500

I'm currently seeing performance issues when we run quiries extracting data from tables with multimilliion records. The data movement is slow and cpu consumption is quite high during the query execution. As a first step, I would like to compare it to t...

Answers: 1

performance Bulk Data Load Sql performance

Error while creating Diagnostic
answered 12-10-2017 05:44:31 -0400

I've gone through the section 7.1 CREATING DIAGNOSTICS of 'Virtual Dataport and Monitoring Tools' but i am getting error as "unexpected error creating diagnostic 'Diag1' " in VDP. I have used correct directory and also all the mentioned file has been c...

Answers: 3

denodo 6.0 performance denodo monitoring and diagnostic tool

Execution time increased after turning on the Cache
answered 13-07-2017 04:25:58 -0400

I am having around 20 services created whose base views are cached and indexed. The performance(execution time) of all the services was improved when I switched to cache database except one service. This one service execution time is increased to more ...

Answers: 1

performance DENODO Denodo Scheduler 6.0 SQL Server

Denodo slow performance during simple select operation.
answered 29-06-2017 07:05:01 -0400

Hello, there is a performance issue when I select data from table (MS SQL Server 2014) through Denodo. SQL from Denodo execution trace is like: SELECT FROM TESTTABLE WHERE FIELD1 = ? AND FIELD2 = ?; Parameters [VALUE1, VALUE2] SQL that is sent to...

Answers: 2