Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

What is maximum limit of hits of Querybuilder

Avatar

Level 6

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

Screen Shot 2022-07-08 at 11.58.22 AM.png

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

View solution in original post

0 Replies

Avatar

Community Advisor

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

Avatar

Correct answer by
Community Advisor

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

Screen Shot 2022-07-08 at 11.58.22 AM.png

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

Avatar

Level 8

@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

Avatar

Employee

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