- querylog.jar.zip - Click Here to download.
Inefficient JCR queries can often be the cause of poor performance. So how do you find queries that take too long to execute?
In CQ 5.5 you can login to Felix Console. Then go to JMX tab and click on QueryStat MBean.
In older versions of CQ you can enable additional logging as described in the Knowledge Base article How to debug JCR Queries.
Once you have query logging you can sort this log file using querylog.jar to find queries with longest execution time. Bellow is an examle of how to use this.
java -Xmx512m -jar querylog.jar query.log > query_sorted.log
- CQCon 2013: Efficient content structures and queries in CQ5
- CQCon 2013: Automated self-testing of live CQ instances
- CQCON 2013: CQ Maven Methods – Mastering Development Workflows that Combine Adobe Experience Manager with Apache Maven and Git
- Adobe Experience Manager at Academy of Art University
- Now available on-demand: May 1st WEM Wednesday Webinar—Mobile Content Management and Personalization