XPath or SQL2?

ariellea4070516

21-12-2018

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!

Accepted Solutions (1)

Accepted Solutions (1)

Jörg_Hoh

Employee

23-12-2018

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