Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
-
Fully Compatible
Description
When running mongod with internalQueryFrameworkControl=trySbeEngine the server seems to spend unnecessary time in determineBonsaiEligibility function (under getExecutorFind).
In the attached flame graph of FindProjectionThreeFields benchmark over a 100-document collection the function takes 3.11% (out of 9.28% for getExecutorFind).
For larger collections this is probably a smaller issue, but it looks like unnecessary overhead for small collections queries.