Guides
Methods to Avoid
If possible, avoid looping row-by-row (tuple-at-a-time) in favor of bulk operations.
Performing row-by-row inserts (even with prepared statements) is detrimental to performance and will result in slow load times.  
> **Best practice.  ** Unless your data is small (<100k rows), avoid using inserts in loops.