Also check with your hosting service too (if you're using one), before you use InnoDB. I know that there are several hosting companies who only allow myISAM tables on certain plans.
> -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 21, 2006 2:31 PM > To: CF-Talk > Subject: Re: SOT: MyISAM or innoDB Storage Engine for MySQL? > > on my mySQL5 installation it created InnoDB tables with everything > when I migrated all my 4.x stuff over from another server. I haven't > noticed any deleterious effects (i.e. slowing stuff down since we all > know myISAM is real fast) and in fact I have seen an increase in > stability; given that there was one particular error that I could > expect a myISAM table to throw every month or so and I haven't had a > single problem yet. But that could be mySQL5 being more stable than > 4.x too. > > Unless you have a specific reason for myISAM I would use innoDB. Its > a more robust table type in general. Just not as fast. > > -- > [EMAIL PROTECTED] > Janitor, MSB Web Systems > mysecretbase.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
