Hi, On Wed, Sep 8, 2010 at 4:23 PM, Gadbury <[email protected]> wrote: > I read somewhere that JCR_SQL2 queries are not yet optimised and it was > recommended to use SQL for the time being until JCR_SQL2 has been optimised. > > I am using JCR_SQL2 to perform some of my queries that use joins. > > Does SQL support joins?
No. > Any news on when JCR_SQL2 queries will be optimised, and whether that will > improve the speed of queries with joins? The relevant issue is JCR-2715 [1]. I've been working on some significant join performance improvements (that also optimize non-join JSR_SQL2 queries) and hope to have this work completed in time for Jackrabbit 2.2 in near future. [1] https://issues.apache.org/jira/browse/JCR-2715 BR, Jukka Zitting
