[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: |
|
||||||||||||||||
| 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 |
| Comments |
| Comment by David Storch [ 27/Jul/23 ] |
|
|
| Comment by Matt Boros [ 27/Jul/23 ] |
|
Sounds good, will mark as dup. |