[SERVER-13842] Optimize non-simple projections Created: 06/May/14  Updated: 06/Dec/22

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

Type: Improvement Priority: Major - P3
Reporter: David Storch Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-12871 Seemingly unreasonable overhead to ra... Closed
Related
is related to SERVER-13337 Re-enable fast path for _id equality ... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

Benchmarking work done in SERVER-13337 shows that 2.6 remains slower than 2.4 for queries with non-simple projections such as exclusion projections.



 Comments   
Comment by Charlie Swanson [ 21/Oct/15 ]

david.storch, If I remember correctly, I was only looking at ProjectionStage::transformSimpleInclusion. I don't think that there are any more obvious improvements in that method, since SERVER-20300 was resolved. There may be other gains to be had elsewhere, but it would need some investigation.

Comment by David Storch [ 21/Oct/15 ]

charlie.swanson, I believe you worked on some optimizations to projection in the query system. Did those apply to non-simple projections? Do you think there is further performance work to do on query projections that we should keep in the backlog?

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