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

Reduce number of batched inserts according to number of indexes

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Replication
    • Repl 2024-07-22, Repl 2024-08-05, Repl 2024-08-19, Repl 2024-09-02, Repl 2024-09-16, Repl 2024-09-30

      Since each index on a collection results in an additional insert at the storage layer, we should reduce our maximum batch size when a collection has more indexes. I would propose we take the value of the kInternalInsertMaxBatchSizeDefault parameter double it (because it was tuned assuming one index, _id), and divide by the number of indexes (when we start) plus 1, and perhaps also have a lower limit of kInternalInsertMaxBatchSizeDefault/10.

            Assignee:
            matthew.russotto@mongodb.com Matthew Russotto
            Reporter:
            matthew.russotto@mongodb.com Matthew Russotto
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: