InnoDB vs MyISAM speed

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
delpino
Forum Newbie
Posts: 1
Joined: Tue Sep 16, 2008 9:39 am

InnoDB vs MyISAM speed

Post 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).
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: InnoDB vs MyISAM speed

Post 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.
(#10850)
Post Reply