You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Thomas Mueller (JIRA)" <ji...@apache.org> on 2014/09/25 15:29:33 UTC
[jira] [Resolved] (OAK-2134) Lucene: not using the path restriction
can speed up queries
[ https://issues.apache.org/jira/browse/OAK-2134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller resolved OAK-2134.
---------------------------------
Resolution: Fixed
Revision 1627538 (trunk)
Revision 1627539 (1.0 branch)
> 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)