This is a discussion on MySQL: What Table Type are you ?> within the alt.comp.lang.php forums, part of the PHP Programming Forums category; Which is better: MyISAM or INNODB ?? All the apps I've written thus far are MyISAM; however, INNODB offers our ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Which is better: MyISAM or INNODB ??
All the apps I've written thus far are MyISAM; however, INNODB offers our dear friend `referential integrity` which can reduce for those of us who are `normalized` (sorry,....getting carried away) Anyway, I realize that referential integrity can be enforced via code ( which I have been doing for years ) but what limitations/strengths does INNODB introduce and would convertind offer any benefits/fallbacks asside from transaction control and foreign key contraints ? Any comments, experiences and opinions are greatly appreciated !! thanks in advance !! |