InnoDB vs MyISAM
from the Artful MySQL Tips List
MyISAM is typically faster for table scans. If the table needs to be updated more than occasionally, the price for this table scan performance advantage will often be more than offset by concurrency and locking issues.
Load Data Infile is much slower with InnoDB, so if huge loads are required, MyISAM may be a better choice at least for a staging table.
Return to the Artful MySQL Tips page