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

Investigate BSBM Explore + UPDATE performance speedups

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: BLAZEGRAPH_2_2_0
    • Component/s: None
    • Labels:
      None

      Description

      In latest benchmarks (BSBM-533) we're observing ~25-30% performance speedups for the BSBM Explore + Update runs. Roughly 10% of the speedup stem from the solution stream update for SPARQL 1.1 (BLZG-1956). We need to understand where the remaining speedup comes from.

        Activity

        Hide
        michaelschmidt michaelschmidt added a comment -

        I traced down the performance improvements for BSBM. Apparently it’s the following change that gave us an additional >20% speedup for the UPDATE queries:

        > https://github.com/SYSTAP/bigdata/pull/464 => "Lifts out the parse of the SPARQL UPDATE request to before we obtain the connection. See BLZG-2039"

        Together with the solution set stream changes for SPARQL UPDATE (which brought us ~10%), we thus observe a speedup of about 30% for the explore + update ! See the summary at https://docs.google.com/spreadsheets/d/1i-JnEy_W5Pt4AWg87oxg564GYkz3zaxxmIS9H4OKssE/edit#gid=130374356 for comparisons of different versions against 2.1 (EXP+UPDATE 16 threads only).

        Show
        michaelschmidt michaelschmidt added a comment - I traced down the performance improvements for BSBM. Apparently it’s the following change that gave us an additional >20% speedup for the UPDATE queries: > https://github.com/SYSTAP/bigdata/pull/464 => "Lifts out the parse of the SPARQL UPDATE request to before we obtain the connection. See BLZG-2039 " Together with the solution set stream changes for SPARQL UPDATE (which brought us ~10%), we thus observe a speedup of about 30% for the explore + update ! See the summary at https://docs.google.com/spreadsheets/d/1i-JnEy_W5Pt4AWg87oxg564GYkz3zaxxmIS9H4OKssE/edit#gid=130374356 for comparisons of different versions against 2.1 (EXP+UPDATE 16 threads only).

          People

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

            Dates

            • Created:
              Updated: