07-22-2011, 03:15 PM
MyISAM OR InnoDB
Required full text Search myISAM
Require Transactions innoDB
frequent select queries myISAM
frequent insert,update,delete innoDB
Row Locking (multi processing on single table) innoDB
Relational base design innoDB
Hi, I have briefly discuss this matter by table so you can conclude which has to be chosen either innodb or MyISAM.
http://developer99.blogspot.com/2011/07/...yisam.html
Required full text Search myISAM
Require Transactions innoDB
frequent select queries myISAM
frequent insert,update,delete innoDB
Row Locking (multi processing on single table) innoDB
Relational base design innoDB
Hi, I have briefly discuss this matter by table so you can conclude which has to be chosen either innodb or MyISAM.
http://developer99.blogspot.com/2011/07/...yisam.html