What is maximum limit of hits of Querybuilder

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

@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

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