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

Always use classic engine for IDhack plans

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 6.2.0-rc0
    • None
    • Fully Compatible
    • v6.0
    • QO 2022-05-16, QO 2022-05-30, QE 2022-10-17, QE 2022-10-31
    • 35

    Description

      As part of the SBE Plan Cache project we tried various optimization to improve the performance of the IDhack queries but were not able to catch up with the classic cache which has a special fast path for generating IDhack plans, which are very simple and very cheap to generate performance wise. To recover the query latency for IDhack plans with the SBE engine turned on as the default we decided to reply on the fall back mechanism and execute these queries with the classic engine. In the future we should revisit this issue and find a proper solution for how to reduce query latency for IDhack queries in SBE.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: