You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Gadbury <ga...@googlemail.com> on 2010/09/08 16:23:09 UTC
JCR_SQL2 Queries
Hi all,
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?
Any news on when JCR_SQL2 queries will be optimised, and whether that will
improve the speed of queries with joins?
--
View this message in context: http://jackrabbit.510166.n4.nabble.com/JCR-SQL2-Queries-tp2531364p2531364.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: JCR_SQL2 Queries
Posted by Jukka Zitting <ju...@gmail.com>.
Hi,
On Wed, Sep 8, 2010 at 4:34 PM, Gadbury <ga...@googlemail.com> wrote:
> Thank you for the quick response. Any idea when 2.2 is likely to release and
> if your optimisations will make it in?
I'd like to target for the beginning of October for Jackrabbit 2.2,
but that's still a bit in the air. More soon on dev@.
I'm pretty optimistic about reaching the release date with the join
optimizations, but that still depends a bit on our priorities at work.
BR,
Jukka Zitting
Re: JCR_SQL2 Queries
Posted by Gadbury <ga...@googlemail.com>.
Thank you for the quick response. Any idea when 2.2 is likely to release and
if your optimisations will make it in?
--
View this message in context: http://jackrabbit.510166.n4.nabble.com/JCR-SQL2-Queries-tp2531364p2531394.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: JCR_SQL2 Queries
Posted by Jukka Zitting <ju...@gmail.com>.
Hi,
On Wed, Sep 8, 2010 at 4:23 PM, Gadbury <ga...@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