SatyaKomatineni3761

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

Note:

**********

This note is informational.

Results are a QUICK observation.

 

Question

***********

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.

 

Cheers

Satya

Outcomes