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: JCR_SQL2 Queries
Date Wed, 08 Sep 2010 14:28:44 GMT
Hi,

On Wed, Sep 8, 2010 at 4:23 PM, Gadbury <gadbury@googlemail.com> 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

Mime
View raw message