On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen <[EMAIL PROTECTED]> wrote:
> On Mon, 23 Sep 2002, Daniel Kiss wrote: > > > Hi! > > > > At 00:56 2002.09.23._ -0300, you wrote: > > >Do I loose > > >too much performance using InnoDB tables in autocommit mode instead of > > >using MyISAM tables? > > > > The real quiestion is: Why do you want to use InnoDB tables when you don't > > want to use its transaction safe features? > > The reason for prefering InnoDB over MyISAM? Performance. Most benchmarks > show InnoDB is slightly faster than MyISAM, and not to mention its some > other benefits. > > But the performance could be a reason on its own to use InnoDB. I don't > mean that MyISAM is bad, not at all. It's simpler to use, after all. But > what I mean is that InnoDB can be used in all tasks MyISAM is suitable > for, and some tasks will be done faster using InnoDB. But some tasks are really bad in InnoDB, at most selects and worst if it comes to table-scans. Thomas mysql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php