Skip to main content
Anny0505
Community Advisor
Anny0505Community Advisor
Community Advisor
September 24, 2021
Solved

Query builder query Limitation in fetching results

I'm trying to understand the how many nodes I can traverse through Query builder query and fetch data from the repository without impacting AEM system performance?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
BrianKasingli
BrianKasingliAccepted solution
Adobe Champion and Community Advisor
September 24, 2021

For AEM 6.0 - 6.2 versions, you can tune the threshold for node traversal via JVM parameters in the AEM start script to prevent large queries from overloading the environment. The recommended values are :

  • -Doak.queryLimitInMemory=500000
  • -Doak.queryLimitReads=100000

for the original post, you can find it here, https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/the-query-read-more-than-500000-nodes-in-memory/m-p/294303

View in thread

5 replies

BrianKasingli
Adobe Champion and Community Advisor
BrianKasingliAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
September 24, 2021

For AEM 6.0 - 6.2 versions, you can tune the threshold for node traversal via JVM parameters in the AEM start script to prevent large queries from overloading the environment. The recommended values are :

  • -Doak.queryLimitInMemory=500000
  • -Doak.queryLimitReads=100000

for the original post, you can find it here, https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/the-query-read-more-than-500000-nodes-in-memory/m-p/294303

Translate
    Anny0505
    Community Advisor
    Anny0505Community AdvisorAuthor
    Community Advisor
    September 25, 2021

    Is it applicable for  latest version of AEM?

    Translate
      BrianKasingli
      Adobe Champion and Community Advisor
      BrianKasingliAdobe Champion and Community Advisor
      Adobe Champion and Community Advisor
      September 27, 2021

      yes

      Translate
        Sanjay_Bangar
        Community Advisor
        Sanjay_BangarCommunity Advisor
        Community Advisor
        September 25, 2021

        Hi @anny0505 ,

             The recommended values are 

        -Doak.queryLimitInMemory=500000

        -Doak.queryLimitReads=100000

         

        Kr,

        Sanjay

        Translate
          joerghoh
          Adobe Employee
          joerghohAdobe Employee
          Adobe Employee
          September 27, 2021

          I think that the question requires 2 distinct answers.

          First, the response by @briankasingli is somehow correct, because it describes the limit of queries. Actually not in terms of the number of response nodes read from the query, but from the number of nodes which are traversed. In the extreme case that's the same number, but in many cases you can fetch much less nodes from the query than indicated by these limits.

           

          The 2nd part of the response is, that you should refine your query as good as you can. And trying to avoid to craft queries, which return very large result sets and traversing them completly. Because this could hit the limits (as outlined by Brian), on the other hand side because it's typically not really fast. And the performance can play a role, depending on the context of the query.

           

          Translate
            Terms & ConditionsAccessibility statement

            Loading footer...