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

Improve performance of IDhack plans in SBE

    • 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
        2. sbefastidhack.svg
          295 kB
        3. sbeidhack.svg
          337 kB

            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: