Speeding up dam:AssetContent search query in CQ 5.6.1 | Community
Skip to main content
Peter_Puzanovs
Community Advisor
Community Advisor
October 16, 2015
Solved

Speeding up dam:AssetContent search query in CQ 5.6.1

  • October 16, 2015
  • 1 reply
  • 640 views

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

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 smacdonald2008

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-performance-tuning

Also - here is an older thread with some suggestions:

http://adobe.ly/1Lkstpe

1 reply

smacdonald2008
smacdonald2008Accepted solution
Level 10
October 16, 2015

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-performance-tuning

Also - here is an older thread with some suggestions:

http://adobe.ly/1Lkstpe