Thanks Jukka, this helped a lot.
I wouldn't ask, why Query.SQL is deprecated, when Query.JCR_SQL2 can't be used due to performance issues :p Kindly regards, Robert Seidel -----Ursprüngliche Nachricht----- Von: Jukka Zitting [mailto:[email protected]] Gesendet: Mittwoch, 18. August 2010 15:06 An: [email protected] Betreff: Re: Slow sql query performance (against xpath) Hi, On Wed, Aug 18, 2010 at 3:02 PM, Seidel. Robert <[email protected]> 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
