Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
SOLVED

QueryBuilder vs SQL2

Avatar

Level 3

Hi,

Could you please let me know which is better to use performance wise: QueryBuilder APIs or SQL2?

I understand QueryBuilder APIs internally converts to XPath queries, however would like to know which will perform better.

Thanks,Souradeep

1 Accepted Solution

Avatar

Correct answer by
Level 10

XPATH is preffered

View solution in original post

5 Replies

Avatar

Correct answer by
Level 10

XPATH is preffered

Avatar

Level 3

Is there any documentation which says the same??

Avatar

Level 3

I am asking if there is any documentation from Adobe which suggests QueryBuilder performs better than SQL2 in AEM 6.

I am asking so because in the below forum as per Justin, QueryBuilder APIs in turn forms XPath queries which finally get converted to JCR-SQL2 in OAK/AEM 6.0. So QueryBuilder APIs and SQL2 are effectively equivalent in AEM 6.

http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manage...

Avatar

Level 3

Hi,

Any answer to the question here would be appreciated.

Thanks, Souradeep