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 Thu, 02 Dec 2010 15:30:48 GMT
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