-
Type: Task
-
Resolution: Won't Do
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
QO 2024-04-15, QO 2024-04-29
PrepareExecutionHelper appears to be intended to be a lightweight wrapper for a bunch of common execution helper functions. As it's implemented, however, it's actually very expensive – for example, its construction and destruction is explicitly expensive in a way that doesn't seem to be necessary, the way that the cached plan and its debugging information are being propagated are also incurring creation and destruction overhead.
Refactoring this class to be less expensive could gain up to ~1.9% runtime performance in getExecutorFind() for classic index scans.
- is depended on by
-
SERVER-89205 Use CRTP to avoid virtual calls in PrepareExecutionHelper
- Closed
- split from
-
SERVER-85417 Investigate potential performance benefit from consulting the plan cache earlier
- Closed
- links to