Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-2134

Lucene: not using the path restriction can speed up queries

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.0.7, 1.1.0
    • lucene
    • None

    Description

      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:

      :fulltext:test
      +:fulltext:test +:path:/path/prefix/*
      

      A workaround is to change the query, by removing the path restriction, and adding a 'like' conditions, as follows (for XPath):

      ... and jcr:like(@jcr:path, '/path/prefix/%')
      

      Attachments

        Issue Links

          Activity

            People

              thomasm Thomas Mueller
              thomasm Thomas Mueller
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: