Details
-
Bug
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
-
Fully Compatible
-
ALL
-
QO 2023-05-29
-
35
Description
Queries with large $in predicate take very long time to optimize in Bonsai.
For instance, the query in the LargeIndexedIns genny benchmark modified to have 500 elements in the $in predicate takes 6ms with Classic and ~2960ms with Bonsai.
The investigation is done as part of SERVER-76981, this task will address the problem.
Attachments
Issue Links
- depends on
-
SERVER-85001 Investigate the performance of Bonsai (M2) based on manually run benchmarks
-
- Closed
-