jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clemens Wyss <clemens...@mysign.ch>
Subject AW: [jira] Commented: (JCR-2715) Improved join query performance
Date Fri, 03 Dec 2010 10:53:35 GMT
I guess it is appropriate to open a new issue herefore...
-> https://issues.apache.org/jira/browse/JCR-2830

> -----Urspr√ľngliche Nachricht-----
> Von: Clemens Wyss [mailto:clemensdev@mysign.ch]
> Gesendet: Donnerstag, 2. Dezember 2010 16:31
> An: dev@jackrabbit.apache.org
> Betreff: AW: [jira] Commented: (JCR-2715) Improved join query
> performance
> 
> Taking iteration into account:
>   SQL 34sec  vs SQL2 95sec
> 
> Making use of offset and limit (i.e. "paging") SQL2 still requires 37 to 59sec
> whereas SQL scales very well (<1sec)
> 
> > -----Urspr√ľngliche Nachricht-----
> > Von: Clemens Wyss (JIRA) [mailto:jira@apache.org]
> > Gesendet: Dienstag, 30. November 2010 17:52
> > An: dev@jackrabbit.apache.org
> > Betreff: [jira] Commented: (JCR-2715) Improved join query performance
> >
> >
> >     [ https://issues.apache.org/jira/browse/JCR-
> > 2715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-
> > tabpanel&focusedCommentId=12965287#action_12965287 ]
> >
> > Clemens Wyss commented on JCR-2715:
> > -----------------------------------
> >
> > just the query.execute() time...
> >
> > > Improved join query performance
> > > -------------------------------
> > >
> > >                 Key: JCR-2715
> > >                 URL: https://issues.apache.org/jira/browse/JCR-2715
> > >             Project: Jackrabbit Content Repository
> > >          Issue Type: Improvement
> > >          Components: jackrabbit-core, query
> > >            Reporter: Jukka Zitting
> > >            Assignee: Jukka Zitting
> > >             Fix For: 2.2.0
> > >
> > >         Attachments: 2010-11-30_PM-04-55-23.zip, SQL2SearchTest.png,
> > ThreeWayJoinTest.png, TwoWayJoinTest.png
> > >
> > >
> > > Our current implementation of SQL2 join queries does not perform
> > > very
> > well on pretty much any non-trivial data set.
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > You can reply to this email to add a comment to the issue online.

Mime
View raw message