Re:The MySQL MyISAM and InnoDB engines and a grocery checkout
by spudlyo on Tuesday October 13, 2009 @05:13PM
(#880094)
I'd vote it down if I could, it's far too fluffy and short for my tastes. The only reason I could think of using MyISAM is if you need features that only it supports, like compression, MRG_MyISAM tables, or full text search.
Having said that, the newer InnoDB plugins support compression, with partitioning you don't need MRG_MyISAM, and you can use something like Sphinx for full text searching, which integrates nicely into MySQL.
Having said that, the newer InnoDB plugins support compression, with partitioning you don't need MRG_MyISAM, and you can use something like Sphinx for full text searching, which integrates nicely into MySQL.