Performance- SQL or QueryBuilder or XPath Queries

[NitroHazeDev]

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,

[smacdonald2008 · Accepted solution]

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]

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.