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

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

26-05-2020

BlogImage.jpg

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.