Uploaded image for project: 'Blazegraph (by SYSTAP)'
  1. Blazegraph (by SYSTAP)
  2. BLZG-2089

Bad performance with path queries in 2.1.4

    Details

      Description

      The following query times out in 2.1.4, used to work before:

      SELECT ?item ?taxonName ?taxonRank ?parentName ?parentRank ?higherParent WHERE {
        ?item wdt:P225 "Rivasmartinezia" .
        ?item wdt:P105 wd:Q34740 .
        ?item wdt:P171/wdt:P225 ?parentName .
        ?item wdt:P171/wdt:P105 ?parentRank .
        ?item wdt:P171+ wd:Q756 .
      }
      

      Removing the last line (P171+) makes it execute in 143 ms and return one ?item which is wd:Q26902704. Also, query:

      ASK {
        wd:Q26902704 wdt:P171+ wd:Q756 .
      }
      

      Returns true in 276 ms. Something seems to break in between those two though as together they time out.

        Activity

        Hide
        michaelschmidt michaelschmidt added a comment -

        I started implementing a query hint to control the gearing (https://github.com/blazegraph/bigdata/tree/BLZG-2089). This seems to work fine, missing some test cases to validate the changes.

        Show
        michaelschmidt michaelschmidt added a comment - I started implementing a query hint to control the gearing ( https://github.com/blazegraph/bigdata/tree/BLZG-2089 ). This seems to work fine, missing some test cases to validate the changes.
        Hide
        michaelschmidt michaelschmidt added a comment -

        Finalized implementation in https://github.com/blazegraph/bigdata/pull/498, running through CI now.

        Show
        michaelschmidt michaelschmidt added a comment - Finalized implementation in https://github.com/blazegraph/bigdata/pull/498 , running through CI now.
        Hide
        michaelschmidt michaelschmidt added a comment -

        CI is green.

        bryanthompson could you please review the implementation?

        Show
        michaelschmidt michaelschmidt added a comment - CI is green. bryanthompson could you please review the implementation?
        Hide
        michaelschmidt michaelschmidt added a comment -

        Merged down.

        Show
        michaelschmidt michaelschmidt added a comment - Merged down.
        Hide
        michaelschmidt michaelschmidt added a comment -

        Brad Bebee Please merge into the branch..

        Show
        michaelschmidt michaelschmidt added a comment - Brad Bebee Please merge into the branch..

          People

          • Assignee:
            michaelschmidt michaelschmidt
            Reporter:
            stasmalyshev stasmalyshev
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: