What is maximum limit of hits of Querybuilder

Forum|Forum|3 years ago
July 8, 2022
3 replies
4693 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

ManviSharma

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

ShaileshBassi

New Participant

@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

SantoshSai

New Participant

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 :