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

Always use classic engine for IDhack plans

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • Fully Compatible
    • v6.0
    • QO 2022-05-16, QO 2022-05-30, QE 2022-10-17, QE 2022-10-31
    • 35

      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.

            anna.wawrzyniak@mongodb.com Anna Wawrzyniak
            anton.korshunov@mongodb.com Anton Korshunov
            0 Vote for this issue
            8 Start watching this issue