[ https://issues.apache.org/jira/browse/JCR-1196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ard Schrijvers resolved JCR-1196. --------------------------------- Resolution: Fixed Fix Version/s: 1.4.1 Assignee: Ard Schrijvers I close this issue as Fixed, since the fix of the hierarchical cache in jackrabbit 1.4 solves the largest problem of this issue. Furthermore, the jira issue is polluted with a lot of comments unrelated to the issue. I will file a new JIRA issue 'Optimize first execution queries for DescendantSelfAxisWeight/ChildAxisQuery' because in 1.4 consecutive executions are fast. I will target for version 2.0 because I do not think in the current architecture we can improve the performance for the first executions. With NGP and perhaps storing paths info in the index we might be able to increase the performance of the first execution. I assume NGP won't be implemented before 2.0. > Optimize queries for DescendantSelfAxisWeight/ChildAxisQuery > ------------------------------------------------------------ > > Key: JCR-1196 > URL: https://issues.apache.org/jira/browse/JCR-1196 > Project: Jackrabbit > Issue Type: Improvement > Components: jackrabbit-core, query > Reporter: Ard Schrijvers > Assignee: Ard Schrijvers > Fix For: 1.4.1 > > Attachments: jcr-repository-xml-dump.xml.bz2 > > > A query like > /documents/en/news//[EMAIL PROTECTED] order by @modificationDate > when there are many nodes ( > 1.000) in /documents/en/news becomes very > slow. I think the bottleneck is in something like recursive filters in > lucene. First off all I'll try to find some stastistics about the > performance, and describe the bottleneck. After that, a solution must be > found, where we need to keep in mind that > 1) these queries run faster and scale better (obviously) > 2) moving a node must stay a cheap operation > Also see: > http://www.nabble.com/Search-performance--%3A-MultiIndex-tf4695559.html#a13421949 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.