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.
