Which performs better for search in in Adobe AEM, SQL2 or the QueryBuilder? | AEM Community Blog Seeding

[kautuk_sahni]

Which performs better for search in in Adobe AEM, SQL2 or the QueryBuilder? by howtoaem Blog

Abstract

Which performs better for search in in Adobe AEM, SQL2 or the QueryBuilder?
I have to make some queries in AEM and I'm not sure if I should go for the QueryBuilder or SQL2. The queries are not particularly complex. I need to find pages using a date range, tags, and resourceType.

Which is the preferred method to make queries in AEM? which one performs better for a big repository.

Best How To:
In CRX2/AEM 5.6.1, XPath performance will be generally faster than JCR-SQL2.

In Oak/AEM 6.0, performance will be approximately equivalent as XPath queries are translated into JCR-SQL2.

Read Full Blog

Which performs better for search in in Adobe AEM, SQL2 or the QueryBuilder?

Q&A

Please use this thread to ask the related questions.