Insert Speed
In 4.1 and beyond, use prepared statements
In older versions
Single inserts are the slowest
Multi-rows inserts are faster
Bulk-loading (LOAD DATA or mysqlimport)
are very, very, very fast
Using InnoDB, use transactions wisely
Many inserts in AUTOCOMMIT mode are
very, very slow
Copyright 2003, Jeremy Zawodny