[jira] [Created] (OAK-2134) Lucene: not using the path restriction can speed up queries

["Thomas Mueller (JIRA)" <ji...@apache.org>]

Thomas Mueller created OAK-2134:
-----------------------------------

             Summary: Lucene: not using the path restriction can speed up queries
                 Key: OAK-2134
                 URL: https://issues.apache.org/jira/browse/OAK-2134
             Project: Jackrabbit Oak
          Issue Type: Improvement
            Reporter: Thomas Mueller
            Assignee: Thomas Mueller
             Fix For: 1.1, 1.0.7


Currently, the Oak Lucene index uses the path restriction in the hope that queries can be faster. However, I found that not using the path restriction is better (much better) in many cases. The following queries were run:

{noformat}
:fulltext:test
+:fulltext:test +:path:/path/prefix/*
{noformat}

A workaround is to change the query, by removing the path restriction, and adding a 'like' conditions, as follows (for XPath):
{noformat}
... and jcr:like(@jcr:path, '/path/prefix/%')
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)