-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Fully Compatible
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.