A Map, A document per row, A document with multiple rows

Discussion created by SatyaKomatineni3761 on Aug 6, 2016
Latest reply on Jan 19, 2017 by david.byrd310011



This note is informational.

Results are a QUICK observation.




what is the performance impact of Map when a document has multiple rows or records  in it vs same number of documents with one document per record.


Some quick results


1. Database to Database (read, map, insert)

2. Volume: 40K

3. With a batch count of 1 on the database read: 50 seconds (Case of 1 record per document)

4. With a batch count of 500 on the database read: 29 seconds (Case of 500 records per document)


Just FYI.


Another note: You may or may not have an opportunity to do this depending on the type of connector or your need to handle errors at a record by record level.