Find out all the Heavy query components in AEM6.3

[srinivas_chann1]

Hi,

Is there any mechanisms in AEM6.3 through which we can find out customs query s that is consuming too much time to respond back even though we have good network.

The purpose is that we would want to improve page load time 

Thanks

[Jaideep_Brar · Accepted solution]

We have Query Manager tool that can be accessed from [1]. It will show the slow/popular queries and how many rows each query traversed.

[1] http://<host>:<port>/libs/granite/operations/content/diagnosistools/queryPerformance.html

[tatvam]

You would want to verify what @Jaideep_Brar suggests. 

Assuming you are talking about page load time in your "site", there might be other factors at play as well

1. Cache ratio
2. Specific component logic
3. Volume of traffic
4. Clientlibs load time in browser
5. breaking JS

If in author, also look at the "developer mode". It should give you component wise breakdown on loading time.

[Varun_Shakya]

Some steps you can follow for page performance:-

1.  In browser Go to Developer Tools-Network Tab and  check which  requests are taking time.

2. OOTB AEM Developer Mode which you can choose and check which component taking more time.

3. And then the JCR Queries. Check the query performance tool also.

Here are some references you can go through to improve your page load time.

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-reduce-page-load-ti...

https://www.albinsblog.com/2018/09/improve-performance-of-adobe-experience.html#.Xvt0dCgzZnI

https://myaemlearnings.blogspot.com/2019/10/aem-page-load-time.html

[Vaibhavi_J]

Hi @srinivas_chann1 , 

You can go through the options mentioned above to check the load time of component. 

If you are looking at improving page speed you need to consider many factors and improvements such as minification of script, image size, cache, blocking of resource etc.

Lighthouse plugin which will part of chrome development tools will be one of the best option to improve the page performance, accessibility, SEO and best practices where it list down the issues and improvement suggestion.