Optimizing MySQL: Batching your write queries

(Steve Meyers) One optimization that I’ve employed several times involves batching write queries. MySQL has some very efficient ways to load multiple rows of data in a single query. Multi-row inserts are one common way to do it, but if you’re adventurous you can also try using LOAD DATA INFILE.

Read More - Register for Free Membership