Page 1 of 1

InnoDB vs MyISAM speed

Posted: Tue Sep 16, 2008 9:42 am
by delpino
Hello all,

not directly related to PHP but I just switched a table from Innodb to MyISAM and suddenly the scripts runs at least 3 times faster. The table has about half a million entries. Is that normal behavior? I switched to Innodb for more security (MyISAM tends to crash once in a while).

Re: InnoDB vs MyISAM speed

Posted: Tue Sep 16, 2008 11:28 am
by Christopher
The two engines use different techniques, so speed differences will occur. The main difference is between record level and table level locking on writes.