Details
-
Improvement
-
Resolution: Done
-
Major - P3
-
None
-
None
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
Issue Links
- duplicates
-
DOCS-1524 Broad guidance for typical performance issues (not just query performance)
-
- Closed
-