[SERVER-13685] refactor fast-path for _id queries to not create a CanonicalQuery Created: 22/Apr/14  Updated: 06/Dec/22  Resolved: 05/Jul/19

Status: Closed
Project: Core Server
Component/s: Performance, Querying
Affects Version/s: 2.6.0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: hari.khalsa@10gen.com Assignee: Backlog - Query Team (Inactive)
Resolution: Won't Do Votes: 1
Labels: query-44-grooming
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-13663 Perf regression for workload that upd... Closed
Duplicate
duplicates SERVER-16891 Special handling of "idhack" queries ... Backlog
Related
is related to SERVER-13337 Re-enable fast path for _id equality ... Closed
Assigned Teams:
Query
Operating System: ALL
Participants:

 Description   

We should be using the idhack more aggressively in .find()s. When possible we should also avoid creating the CanonicalQuery for idhack .find() queries.



 Comments   
Comment by David Storch [ 05/Jul/19 ]

This is an old idea for improving the performance of find-by-_id queries that I don't see a reason to pursue right now. From an internal engineering perspective, it's better if all queries are represented by a CanonicalQuery rather than skipping this part of the code path. Closing this ticket as Won't Do.

Comment by David Storch [ 25/Apr/14 ]

Splitting this into two tickets. This one will be for not creating a CanonicalQuery in the idhack path. Re-enabling projection for the idhack will be covered by SERVER-13337.

Generated at Thu Feb 08 03:32:33 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.