XPath or SQL2? | Community
Skip to main content
ariellea4070516
Level 3
Dec 22, 2018 12:43 AM UTC
Solved

XPath or SQL2?

Which is the recommend query language in AEM's current lifecycle: XPath or SQL2?

One HelpX article (with a timestamp of 2018 but that does not appear to have been updated since 6.3) says XPath over SQL2

Oak Queries and Indexing

While a HelpX resource with an earlier timestamp of 2017 says SQL2 over XPath

Describing the JCR model in Adobe Experience Manager | at 2:15

Which is the correct recommendation and why?

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
joerghoh
joerghohAccepted solution
Employee
Dec 23, 2018 5:18 PM UTC

At the moment there is no clear recommendation. Both are supported and the performance of both is comparable. From a specification point of view XPath is deprecated, but the Oak team made the statement at some occassions that they don't plan to drop XPath support.

Jörg

2 replies

ariellea4070516
Level 3
Dec 24, 2018 5:53 PM UTC

Thanks, Jörg!

Translate
joerghoh
joerghohAccepted solution
Employee
Dec 23, 2018 5:18 PM UTC

At the moment there is no clear recommendation. Both are supported and the performance of both is comparable. From a specification point of view XPath is deprecated, but the Oak team made the statement at some occassions that they don't plan to drop XPath support.

Jörg

Translate