[SERVER-80360] Regression in serializing large $in lists Created: 23/Aug/23  Updated: 29/Oct/23  Resolved: 24/Aug/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Joshua Lapacik (Inactive) Assignee: Joshua Lapacik (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-85105 Tracking: PM-2885 Milestone 0 Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: QO 2023-09-04
Participants:

 Description   

$in lists are being sorted and de-duplicated before serialization.

The sorting and de-duplicating of large $in lists has significantly improved the execution times of those queries, however for query stats it has made serialization much more expensive leading to regressions of such queries when compared against the baseline.

large $in query without query stats

large $in query with query stats

The regression (pertaining to query stats) was introduced by https://jira.mongodb.org/browse/SERVER-76904, and specifically this line.



 Comments   
Comment by Githook User [ 24/Aug/23 ]

Author:

{'name': 'joshua', 'email': '80741223+jlap199@users.noreply.github.com', 'username': 'jlap199'}

Message: SERVER-80360 Fix query stats in list serialization perf regression
Branch: master
https://github.com/mongodb/mongo/commit/5d7f7840f09ab68d03a582ebf33bab98d9634da4

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