myisam or innodb (chestnut)

2005-07-13 Thread zzapper
Hi, I created the same database on two different servers (with different versions of mysql). I found one db had been created as innodb and the myisam without me apparently having a say in the matter. I've Googled and found that Innodb has record locking, roll back, but that MYISAM is quicker.

Re: myisam or innodb (chestnut)

2005-07-13 Thread tony
On Wed, 2005-07-13 at 15:02 +0100, zzapper wrote: Is myisam still dominant for web applications? depends on your application, if you're running a bulliten board or a simple catalogue site, then myisam is a good choice as it is faster. However for an ecommerce site i would definately go for