Re: Slow sql query performance (against xpath)

[Jukka Zitting]

Hi,

On Wed, Aug 18, 2010 at 3:02 PM, Seidel. Robert <robert.sei...@aeb.de> wrote:
> q = qm.createQuery(queryString, Query.JCR_SQL2);

Use this instead:

q = qm.createQuery(queryString, Query.SQL);

The JCR_SQL2 support in Jackrabbit is tied to our join implementation,
which hasn't yet be optimized for performance (see also JCR-2715).

BR,

Jukka Zitting