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

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.