|
On bestbuy_query and bestbuy_agg workloads SBE engine experiences worse performance changes than classic engine when comparing sharded vs non-sharded collections.
Example:
| Query |
Engine |
Non-sharded ops/sec |
Sharded ops/sec |
Diff |
| count_no_predicate-useAgg {thread_level: 1} |
Classic |
0.75 |
0.50 |
33% |
| count_no_predicate-useAgg {thread_level: 1} |
SBE |
1.12 |
0.57 |
49% |
| find_project_6_sort_indexed_skip_limit_1-noAgg {thread_level: 1} |
Classic |
1472 |
378 |
74% |
| find_project_6_sort_indexed_skip_limit_1-noAgg {thread_level: 1} |
SBE |
2035 |
412 |
79% |
|