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

BSBM Q5 performance optimization

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Accepted
    • Resolution: Unresolved
    • Affects Version/s: QUADS_QUERY_BRANCH
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Bigdata scores over 17,000 QMpH (Query Mixes Per Hour) without Q5 of BSBM and only ~3000 QMpH when it is included in the query mix.

      Examine the evaluation plan for this Q5 in detail as it has a tremendous impact on our BSBM performance. Without it we see the following on the 100M data set:

      17301	QMpH
      ---------------------
      430.15	Q1
      275.63	Q2
      91.07	Q3 
      135.11	Q4
      N/A	Q5
      52.87	Q7
      60.11	Q8
      210.07	Q9
      83.68	Q10
      125.33	Q11
      173.77	Q12
      

      Looking at the 100M performance matrix[1], it is clear that we are still a bit slow on Q3 and Q9 when compared to some of the other stores, but fixing Q5 should go a long way to improving our total performance on that benchmark.

      [1] http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/results/V6/

        Attachments

          Activity

            People

            Assignee:
            michaelschmidt michaelschmidt
            Reporter:
            bryanthompson bryanthompson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: