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).
InnoDB vs MyISAM speed
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: InnoDB vs MyISAM speed
The two engines use different techniques, so speed differences will occur. The main difference is between record level and table level locking on writes.
(#10850)