[SERVER-75591] Improve SBE perf for bestbuy_query and bestbuy_agg when sharded Created: 03/Apr/23  Updated: 04/Apr/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Ivan Fefer Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
Assigned Teams:
Query Execution
Participants:

 Description   

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%

 

 


Generated at Thu Feb 08 06:30:34 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.