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

XPath queries with both path and property restrictions are slow

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.17
    • Component/s: query
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: