What is maximum limit of hits of Querybuilder | Community
Skip to main content
A
akshaybhujbale
Level 6
July 8, 2022
Solved

What is maximum limit of hits of Querybuilder

  • July 8, 2022
  • 3 replies
  • 4694 views

Hey Team

I want to know what is the maximum numbers of hits for any search query request on quarybuilder.

support.

Simply I want to know rate limit of querybuilder per query request.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SantoshSai

@akshaybhujbale That's same, please check below screenshot on AEM 6.5

You can check here at /system/console/configMgr#org.apache.jackrabbit.oak.query.QueryEngineSettingsService

(Apache Jackrabbit Query Engine Settings Service) in configuration manager

Reference: https://experienceleague.adobe.com/docs/experience-manager-64/developing/bestpractices/troubleshooting-slow-queries.html?lang=en#detecting-large-result-set-queries

3 replies

SantoshSai
Community Advisor
SantoshSaiCommunity Advisor
Community Advisor
July 8, 2022

hi @akshaybhujbale ,

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-5...

Regards,

Santosh

Santosh Sai
    A
    akshaybhujbaleAuthor
    Level 6
    July 8, 2022

    HI @santoshsai 

    Can you please let us know for AEM 6.5

     

      SantoshSai
      Community Advisor
      SantoshSaiCommunity AdvisorAccepted solution
      Community Advisor
      July 8, 2022

      @akshaybhujbale That's same, please check below screenshot on AEM 6.5

      You can check here at /system/console/configMgr#org.apache.jackrabbit.oak.query.QueryEngineSettingsService

      (Apache Jackrabbit Query Engine Settings Service) in configuration manager

      Reference: https://experienceleague.adobe.com/docs/experience-manager-64/developing/bestpractices/troubleshooting-slow-queries.html?lang=en#detecting-large-result-set-queries

      Santosh Sai
        ShaileshBassi
        Community Advisor
        ShaileshBassiCommunity Advisor
        Community Advisor
        July 8, 2022

        @akshaybhujbale By default, the query builder json servlet displays a maximum of 10 hits.

        Adding the following parameter allows the servlet to display all query results:

        p.limit=-1

         

        Returning all results

        The following query will return ten results (or to be precise a maximum of ten), but inform you of the Number of hits: that are actually available:

        http://localhost:4502/bin/querybuilder.json?path=/content&1_property=sling:resourceType&1_property.value=foundation/components/text&1_property.operation=like&orderby=path

        path=/content
1_property=sling:resourceType
1_property.value=foundation/components/text
1_property.operation=like
orderby=path

        The same query (with the parameter p.limit=-1) will return all results (this might be a high number depending on your instance):

        http://localhost:4502/bin/querybuilder.json?path=/content&1_property=sling:resourceType&1_property.value=foundation/components/text&1_property.operation=like&p.limit=-1&orderby=path

        path=/content
1_property=sling:resourceType
1_property.value=foundation/components/text
1_property.operation=like
p.limit=-1
orderby=path

         

        Thanks

          ManviSharma
          Adobe Employee
          ManviSharmaAdobe Employee
          Adobe Employee
          July 10, 2022

          Hi,

           

          >The recommended values are 

          -Doak.queryLimitInMemory=500000

          -Doak.queryLimitReads=100000

           

          >You can tune the threshold for node traversal via JVM parameters in the AEM start script to prevent large queries from overloading the environment.

          > Please refer below doc for more information:

           https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/the-query-read-more-than-5...

           

          >By default, the query builder JSON servlet displays a maximum of 10 hits.

           

          Regards,

          Manvi Sharma

            Terms & ConditionsAccessibility statement

            Loading footer...