[SERVER-79393] Expression parameterization input param ID generation is slow for large queries Created: 26/Jul/23  Updated: 27/Jul/23  Resolved: 27/Jul/23

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

Type: Task Priority: Major - P3
Reporter: Matt Boros Assignee: Backlog - Query Optimization
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-79092 Optimize the expression search for pa... Closed
Related
is related to SERVER-62509 Write tests to stress ABT and Bonsai Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

nextReusableInputParamId linearly searches through all expressions stored so far for duplicates when parameterizing match expressions. This is slow for queries with a large number of predicates under an and/or. This blocks SERVER-62509 from running all stress tests.



 Comments   
Comment by David Storch [ 27/Jul/23 ]

SERVER-79092 is on the backlog though and not scheduled. If this is posing a real performance problem in the context of SERVER-62509, then I would think that SERVER-79092 should be scheduled.

Comment by Matt Boros [ 27/Jul/23 ]

Sounds good, will mark as dup.

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