Re: Bulk Insert Prepared Statement

[Rick James]

The performance difference between 100 and 1000 rows at a time is not much.

Empirically, inserting 1000 rows
1 at a time: 1000*(10+1) = 11,000 units of time
10 at a time: 100*(10+10) = 2,000
100 at a time: 10*(10+100) = 1,100
1000 at a time: 1*(10+1000) = 1,010
(The "10" is an estimate of the overhead of the network and parsing the query.)
So, based on this estimate, 1000 rows at a time is only 9% faster than 100 rows at a time.