Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: Querying, Sharding
Labels:
None

Assigned Teams:

Query Execution
Case:
Confidence Status:
None
Work Order:
3

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name:
None
Goal Link:
None

Selecting the appropriate shard to send a query to takes a long time on $in queries. ~~SERVER-4745~~ mitigates the affect of this, but this code could use rewriting and further optimization.

is duplicated by

SERVER-9205 MongoS does not re-write $in queries which results in all terms in $in array being sent to all shards

Closed

is related to

SERVER-50299 Shard Targeting for $in statements

Closed

related to

SERVER-4745 Figuring out which shard to send a query to takes a long time when doing large $in queries on the shard key

Closed

SERVER-4555 check and clean sharding utilization of queryutil code

Closed

SERVER-9332 Mongos should re-write $in queries on the shard key before sending them to the shards so that the shards only receive the relevant portion of the $in

Closed

Assignee:: [DO NOT USE] Backlog - Query Execution
Reporter:: Spencer Brody (Inactive)
Participants:: [DO NOT USE] Backlog - Query Execution, Aaron Staple, Antoine Girbal, Ben, Spencer Brody
Votes:: 6 Vote for this issue
Watchers:: 25 Start watching this issue

Created:: Feb 13 2012 07:56:30 PM UTC
Updated:: Dec 06 2022 05:36:24 AM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates