[SERVER-3473] scan and order always loads the full document Created: 25/Jul/11  Updated: 27/Jan/15  Resolved: 27/Jan/15

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

Type: Improvement Priority: Major - P3
Reporter: Aaron Staple Assignee: David Storch
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-15221 Planner sort analysis should not add ... Closed
Participants:

 Description   

This has come up a few times recently - when we scan and order a doc we always load the full doc rather than sorting based on index keys when possible. There may be some concurrency related issues to deal with if we want to change this behavior, since I believe right now the full doc is kept in the result set and never re-read. One thing we could probably do pretty easily is check if a doc will fit within the sort limit (at the current point of an index scan) using index keys and then only load the doc if it does in fact look like it will fit.



 Comments   
Comment by David Storch [ 27/Jan/15 ]

This ticket is duplicated by SERVER-15221. Closing in favor of the newer ticket, as it uses new query planner terminology and refers to the new code.

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