jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jukka Zitting <jukka.zitt...@gmail.com>
Subject Re: Slow sql query performance (against xpath)
Date Wed, 18 Aug 2010 13:06:27 GMT
Hi,

On Wed, Aug 18, 2010 at 3:02 PM, Seidel. Robert <Robert.Seidel@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

Mime
View raw message