Hi.
Heikki, please correct me, if I say something stupid. ;-)
On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote:
> Deryck, others:
>
> I'm doing some reading on InnoDB and am pretty ignorant on the subjets.
> Can someone explain why would InnoDB be faster than MySQL?
Please note that InnoDB also belongs to MySQL. What you probably mean
is the MYISAM table type. InnoDB is "just another" table type.
> From what I read it looks like it will have more overhead to support
> the transactions and that should decrease the performance rather
> than improve it.
If you use transactions, InnoDB will be a lot slower than MYISAM
tables. InnoDB seems to be faster, if you disable commits (or at least
the disk flushes connected with that). I think, one of the main
reasons that it can be faster than MYISAM tables is that it
preallocates disk space.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
