-
Type: Task
-
Resolution: Unresolved
-
Priority: 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.
- depends on
-
SERVER-67610 Use RuntimeEnvironment for index key corruption checks
- Closed
- is depended on by
-
SERVER-67610 Use RuntimeEnvironment for index key corruption checks
- Closed
- is related to
-
SERVER-69751 Investigate SBE Linkbench regressions
- Closed
- related to
-
SERVER-66435 Always use classic engine for IDhack plans
- Closed