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
    December 1, 2022

    Hi @santoshsai 

    Can we set up call to discuss this.

    Actually we are facing some issues and this have critical usecase for us.

    Please let us no if possible when we can setup call?

     

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