Is one big mysql insert quicker or just the same speed as a Load Data Infile insert?

[john278]

Hi,

I have made a script so that it does one bulk insert of 1,000 rows at a time. Would using Load Data Infile on the same 1,000 rows be quicker or just the same speed when uploading data to the database? And if so, then how much faster would it rougthly be?

I have looked high and low, but could not find anything about this. In MySQL it says that it can be up to 20 times faster, but that is for single insert for each row. I am doing just one large insert and not individual inserts per row.

[longneck]

have you tried benchmarking it yourself?