Hello,
I have a scenario wherein i have a nested node structure upto 5 levels deep, and further. When i run a Query builder Query, i see the performance is slow compared to XPath and SQL,SQL2
Was wondering if someone could let me know what is the best recommendation , SQL2, Xpath Querybuilder or SQL performance wise
I have more than 25000 nodes that it would have to query and using AEM 5.6.1
Regards,
Solved! Go to Solution.
Views
Replies
Total Likes
It all depends on how you structure your queries. Check this Performance KB:
https://helpx.adobe.com/experience-manager/using/performance-faq.html
Views
Replies
Total Likes
It all depends on how you structure your queries. Check this Performance KB:
https://helpx.adobe.com/experience-manager/using/performance-faq.html
Views
Replies
Total Likes
Consider moving your content into Solr.
Solr Query for 25,000 items will be instant(less then a millisecond). You will also allow to spend your CQ box CPU on more useful tasks.
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies
Views
Likes
Replies