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

Improve performance of IDhack plans in SBE

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Won't Fix
    • None
    • None
    • None
    • QE 2022-09-19, QE 2022-10-03, QE 2022-10-17
    • 2

    Description

      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.

      Attachments

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

        Issue Links

          Activity

            People

              anna.wawrzyniak@mongodb.com Anna Wawrzyniak
              anton.korshunov@mongodb.com Anton Korshunov
              Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: