On Wed, Jan 5, 2011 at 2:58 PM, Ronald Bradford <[email protected]>wrote:
> InnoDB can even perform better then MyISAM in high read environment if you > have a good ratio of data in memory (i.e. innodb_buffer_pool_size). > > <snip> > > On Wed, Jan 5, 2011 at 2:48 PM, Hans Zaunere <[email protected]> wrote: > >> > If you have 20 data tables with a lot of relationships among them, do >> > you think that is reason enough to choose InnoDB -- with its support for >> > transactions and foreign keys -- over MyIsam? >> >> If you need transactions and foreign keys, then yes. >> >> > I'm working on an app and taking great pains to preserve integrity at >> > the application level and coming to realize that it's even harder than I >> >> Don't - it's not really possible, and if you truly need that type of >> thing, >> it has to be done in the database anyway. >> > <snip> Oh. Er, um, apology for posting withdrawn. Guess I'll change my mind again, independent thinker that I am. Or call it flexible, open-minded... anyway: one ad hominem line of reasoning that has influenced me is that giants like Drupal and Wordpress seem to favor myisam and if it's good enough for them... Why do you suppose they go for myisam? Performance performance performance? -- David Mintz http://davidmintz.org/ It ain't over: http://www.healthcare-now.org/
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
