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

XPath queries with both path and property restrictions are slow

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.17
    • query
    • None

    Description

      XPath queries such as

      /jcr:root/a//b/c/d/*[@type='1' or @type='2'] 
      

      are slow because they don't currently use an index on the property "type".

      They are converted to a join, with selectors a joining b joining c and so on. Maybe it would be better to join in reverse order, or the query engine might need to reverse join order in this case (once an index is used).

      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: