Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-66437

Improve performance of IDhack plans in SBE

XMLWordPrintableJSON

    • Type: Icon: Task Task
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • QE 2022-09-19, QE 2022-10-03, QE 2022-10-17
    • 2

      As part of PM-2371 we collected a perf profile for the SBE engine with the new SBE plan cache. Based on the collected results it appeared that the classic engine is still ~20% faster when executing IDhack plans and the plan cache project couldn't close this gap. We still spend a lot of time recovering the plan from the cache and preparing for execution in SBE. The classic engine does it dead simple but exercising through a fast path of constructing a plan consisting of a single stage. We need to find a way to allow the SBE engine to compete on this type of queries with the classic engine.

        1. classicidhack.svg
          294 kB
          Mihai Andrei
        2. sbefastidhack.svg
          295 kB
          Mihai Andrei
        3. sbeidhack.svg
          337 kB
          Mihai Andrei

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            anton.korshunov@mongodb.com Anton Korshunov
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated: