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.