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.
user
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](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/optimizing_queries/data_movement/data_movement#data-movement) * [Optimizing the Join operation](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/optimizing_queries/optimizing_join_operations/optimizing_join_operations#optimizing-join-operations), if any. * Enabling [Automatic Simplification of Queries](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/optimizing_queries/automatic_simplification_of_queries/automatic_simplification_of_queries#automatic-simplification-of-queries). * [Full Cache Mode](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cache_module/cache_modes/full_mode#full-mode) For more information, you can have a look at [Limit the Maximum Amount of Memory of a Query](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/memory_management/limit_the_maximum_amount_of_memory_of_a_query/limit_the_maximum_amount_of_memory_of_a_query#limit-the-maximum-amount-of-memory-of-a-query) and [Optimizing Queries](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/optimizing_queries/optimizing_queries#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