Performance- SQL or QueryBuilder or XPath Queries | Community
Skip to main content
N
NitroHazeDev
New Participant
October 16, 2015
Solved

Performance- SQL or QueryBuilder or XPath Queries

  • October 16, 2015
  • 2 replies
  • 1472 views

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,

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

It all depends on how you structure your queries. Check this Performance KB:

https://helpx.adobe.com/experience-manager/using/performance-faq.html

2 replies

smacdonald2008
smacdonald2008Accepted solution
New Participant
October 16, 2015

It all depends on how you structure your queries. Check this Performance KB:

https://helpx.adobe.com/experience-manager/using/performance-faq.html

Peter_Puzanovs
Peter_Puzanovs
New Participant
October 16, 2015

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.

Terms & ConditionsAccessibility statement

Loading footer...