 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
• |
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
|
|