What is maximum limit of hits of Querybuilder

[akshaybhujbale]

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.

[SantoshSai]

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

[akshaybhujbale]

HI @SantoshSai 

Can you please let us know for AEM 6.5

[SantoshSai · Accepted solution]

@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/troubleshooti...

[akshaybhujbale]

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]

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

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

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

Thanks

[ManviSharma]

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