Boost MySQL insert speed

Inserting many records en masse into a MySQL database can be a challenge when it comes to performance.

LOAD DATA INFILE can help, together with certain optimisations.

More info:

https://stackoverflow.com/a/2504211

I'm Andrew Gee, a Solution Architect working in the Birmingham area of the UK. This is my tech blog. Connect with me on LinkedIn.