Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-1680

Documentation on bulk inserts is incomplete

    XMLWordPrintableJSON

Details

    Description

      Bulk inserts in MongoDB are not like bulk inserts in the RDBMS, and the documentation doesn't make the differences clear

      Among the topics that should be covered are:

      • Bulk inserts typically have no (or vanishingly small) performance improvement on a sharded cluster (since the mongos has to split apart each insert & route it to the appropriate shard)
      • Bulk inserts to un-sharded MongoDB can slow down overall cluster performance by flooding the I/O system on a PRIMARY node
      • Generally, there's typically no performance improvement in including more than 10-20 documents in a bulk insert
      • There are trade-offs when doing bulk inserts: in particular, you lose the ability to determine which inserts succeeded and which ones failed

      Attachments

        Activity

          People

            Unassigned Unassigned
            william.zola@10gen.com William Zola
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              10 years, 22 weeks, 1 day ago