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

find command on unsharded collection through mongos returns too much data from mongod to mongos

    • Minor Change
    • Query 2019-12-16, Query 2019-12-30, Query 2020-01-13
    • 0

      It looks like when SERVER-19355 was implemented the logic for handling sort/skip/limit that gets sent to shards gets sent to primary shard for queries on unsharded collections as well.

      This results in mongod returning more documents to mongos and mongos then applying the skip rather than mongod just returning only the required data to mongos (after applying the skip and limit).

      Not sure if this is a bug or just a missed opportunity for optimization.

            Assignee:
            eric.cox@mongodb.com Eric Cox (Inactive)
            Reporter:
            asya.kamsky@mongodb.com Asya Kamsky
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: