Getting a list of pages and components | Querying vs Traversal

[manass33544664]

Hi,

We need to traverse our entire content repository and return a list of all pages and all the components authored in each of these pages.

The number of pages are high. I can think of the below ways and need views and suggestions from the community.

1. Using Queries. We need to run the query at each market level (eg content/domain/market1 , content/domain/market2 etc) and get the results. This works but since the number of nodes are pretty high, this takes quite some time (we are still trying to tune some indexes though)

2. The component Report which is available out of the box. Two questions here

     a. Will this report give back result in a json format?

     b. Does this report internally use queries only?

3. Write a custom code using Resource Resolvers and creating the required json.

Regards,

Manas

[Techaspect_Solu · Accepted solution]

Hi Manas,

2) Yes, the component report returns the result in json format.

Please hit the below URL to see the json data (Component report)

http://localhost:4502/etc/reports/compreport/jcr:content/report.data.json

1) To understand the best practices for querying and indexing, please refer:

https://docs.adobe.com/content/docs/en/aem/6-1/deploy/best-practices/best-practices-for-queries-and-...

Different ways to access JCR and their performance aspects are mentioned here:

https://cqdump.wordpress.com/2012/11/26/ways-to-access-your-content-with-jcr-part-1/

https://cqdump.wordpress.com/2012/11/28/ways-to-access-your-content-with-jcr-part-2-performance-aspe...

We hope this information helps!

Regards,

TechAspect Solutions

[smacdonald2008]

Thanks Techaspect Solutions Pvt Ltd for the awesome community input!

[manass33544664]

Thanks for the great input.Let me try these options