Speeding up dam:AssetContent search query in CQ 5.6.1

[Peter_Puzanovs]

Have been analysing slow component, came to conclusion that it is due to the slow running Query:

map.put("property","jcr:primaryType"); map.put("property.value","dam:AssetContent"); map.put("2_group.property","metadata/item:enabled"); map.put("2_group.property.1_value","true"); map.put("orderby","@jcr:lastModified"); map.put("orderby.sort","desc");

Have come across this document: https://helpx.adobe.com/experience-manager/kb/SearchIndexingConfig.html

This document desribes functionality for CQ 5.4 and CQ 5.5 it does not describe changes that have happened in CQ 5.6.1.

Would optimization to the indexing_config.xml help in this particular case, where is the config file located in 5.6.1?

Was thinking to add following config to the file:

<aggregate primaryType="dam:AssetContent"> <include>*</include> <include>*/*</include>     <include>*/*/*</include> </aggregate>

Would this help or is there easier route to increase Query speed?

Thanks,

Peter

[smacdonald2008 · Accepted solution]

Try using the Query Tool to check and see if there are improvements. 

There are some good articles on this tool and some talk about performance too:

http://cq-ops.tumblr.com/post/23543240500/how-to-use-cqs-query-debugger-tool

http://www.cqtutorial.com/courses/cq-admin/cq-admin-lessons/cq-performance-tuning/cq-search-performa...

Also - here is an older thread with some suggestions:

http://adobe.ly/1Lkstpe