How to: Use MySQL fast LOAD DATA for UPDATEs - Software Projects Inc.
Dealing with massive amounts of data in MySQL, one of the first lessons you are taught is - -- Use LOAD DATA for quickly inserting lots of records into a table-- Avoid multiple Inserts. From MySQL documentation "The LOAD DATA INFILE statement reads rows ....