Hope you are aware about AEM 6.2 onward there is configuration available
in AEM and threshold is setup to restrict any query execution which may
cause impact to instance.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=100000In AEM 6.3,
the above 2 parameters are preconfigured by default, an...