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:[email protected]] > Gesendet: Donnerstag, 2. Dezember 2010 16:31 > An: [email protected] > 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:[email protected]] > > Gesendet: Dienstag, 30. November 2010 17:52 > > An: [email protected] > > 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.
