Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-50299

Shard Targeting for $in statements

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      HI 

      Working with a Client we were exploring ways to mitigate load issues on the mongod hosts on a Sharded cluster. 

      The particular client is doing multiple $in statements in each query but have large lists for up to 1000 entries per $in part.  Based on testing on both Our and the client side we were able to see significant advantages of trying to target each $in's entries to a single shard. Thus avoiding scatter gather queries foe each fo the $in queries.

      The optimisation could be both on the mongos or on the driver side, and on the dirver and could make it invisible to the client.

            Assignee:
            max.hirschhorn@mongodb.com Max Hirschhorn
            Reporter:
            dawid.esterhuizen@mongodb.com Dawid Esterhuizen
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: