"jinxidoru" <net> wrote:
This may be true in some cases. But not in general.
Here is a refined statement: InnoDB may be faster if there are many
independent connections to the database. InnoDB will probably be
faster if there are concurrent reads/writes. In a single-thread
scenario MyISAM will almost always be faster than InnoDB.
But: InnoDB provides some important features that MyISAM lacks
- foreign key constraints
- row level locks
Maybe you ran your InnoDB benchmarks with AUTO_COMMIT=On. This will
kill all performance.
Axel Schwenke, Senior Software Developer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/