Performance- SQL or QueryBuilder or XPath Queries | Adobe Higher Education
Skip to main content
N
NitroHazeDev
Level 9
October 16, 2015
Risolto

Performance- SQL or QueryBuilder or XPath Queries

  • October 16, 2015
  • 2 risposte
  • 1476 visualizzazioni

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,

Questo argomento è stato chiuso alle risposte.
Migliore risposta di 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 risposte

smacdonald2008
smacdonald2008Risposta
Level 10
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
Community Advisor
Peter_PuzanovsCommunity Advisor
Community Advisor
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.

Termini e CondizioniAccessibility statement

Loading footer...