-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 7.0.0
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
ALL
-
-
QO 2024-07-22
It appears that somewhere between 6.0.15 and 7.0 the parsing of a large constant array given as input to $filter got about 2x to 4x slower...
Using the script below I get:
Array Length | Execution 6 | Explain 6 | Execution 7 | Explain 7 |
---|---|---|---|---|
10 | 1 | 0 | 1 | 1 |
100 | 1 | 1 | 6 | 5 |
1000 | 7 | 5 | 12 | 10 |
10000 | 63 | 49 | 110 | 105 |
100000 | 695 | 530 | 1200 | 1110 |
so it seems to stabilize at 2x which is not great but it's pretty horrible at specific example size I originally tried (like 4x). Also 7.0.0 was bad but 7.0.11 seemed to be worse.
- is caused by
-
SERVER-87736 Backport query stats to 6.0
- Closed
- is fixed by
-
SERVER-92298 Remove unused ProjectionPathASTNode argument to speed up $project aggregation requests
- Closed
- related to
-
SERVER-92374 Investigate remaining regression in parsing $project queries with a large constant array
- Closed