You can translate the question and the replies:

Performance of a view based on a MongoDB data source

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.6 million records and 256 columns. Running the query Select max(date) from ... on Base View level results in a runtime of about 10 seconds. On Integration View level the same query takes 70 seconds, on Business View level more than 2 minutes. The Base View is passed through to the higher levels only 1:1 without any further conditions, joins or anything else. Can this performance degradation be caused by the size of the table alone or are there possibilities to improve the performance by further settings? An index was created in MongoDB as well as in Denodo, but did not lead to any improvement. Did not want to do this via the cache. Best thanks
user
02-05-2022 08:34:00 -0400

1 Answer

Hello, Just from the description it is not possible to determine what is happening. In terms of maximizing performance I would recommend you to have a look at [this](https://community.denodo.com/kb/en/view/document/Best%20Practices%20to%20Maximize%20Performance%20IV%3A%20Detecting%20Bottlenecks%20in%20a%20Query) Knowledge Base article, as there is some good guidance on how to debug these bottlenecks! If you have a support user you can also try and open a Support Case and ask for further help, as someone will be able to better assist you! Hope this helps!
Denodo Team
03-05-2022 11:03:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here