InnoDB vs MyISAM speed
Posted: Tue Sep 16, 2008 9:42 am
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).
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).