I did a benchmark and multi-row insert with a single statement is about 6-7% faster than batch insert. This is for 250 rows executed a thousand times in a loop (alternating between the two to reduce subsequent table insert index slowdown). So a little faster but not significantly so.
Yes that's correct. A multiple row insert with a single insert statement. I'll try benchmarking the two on Monday. My guess is that they are pretty damn similar.
Sent from my iPhone
On Jun 6, 2015, at 10:35 AM, Dave Cramer <pg@fastcrypt.com> wrote: