You can translate the question and the replies:

Query memory Usage: need to find a better alternative to handle large queries

Hi, Settings of memory usage: Maximum query size: 200 MB swapping status: ON Max size in memory of each node: 50 MB Max size of blocks stored: 200 KB There is a view which is using more than the specified memory. We don't want to increase the memory usage but want to find a better way in which we can handle this scenario.
24-02-2021 03:21:00 -0500

1 Answer

Hi, When I face issue with larger queries I would do the following, * Limit the Maximum Amount of Memory of a Query. * Delegate the query processing to the underlying source, as much as possible. * Apply the Optimization techniques such as * [Data Movement]( * [Optimizing the Join operation](, if any. * Enabling [Automatic Simplification of Queries]( * [Full Cache Mode]( For more information, you can have a look at [Limit the Maximum Amount of Memory of a Query]( and [Optimizing Queries]( sections of Virtual DataPort Administration Guide. If you need further assistance and you have an active support account, you could open a support ticket and support team will assist you. Hope this helps!
Denodo Team
25-02-2021 01:51:35 -0500
You must sign in to add an answer. If you do not have an account, you can register here