> InnoDB requires you to pre-allocate a large tablespace file (like
> Oracle),
This hasn't been the case since Oracle 7.3.2.3. Create your
datafiles with autoextend on.
Dave
which it then uses to put indices and data in. It's also
> index-organized based on primary key, so for certain operations it's
> slower than MyISAM.
>
> BDB tables are index-organized as well, and use page-based locks
> (around 8K I think) instead of record locks like InnoDB.
>
> The primary value of MyISAM tables are their speed when selecting from
> them, since they don't support transactions and locking is so simple.
> But, beware that table data is not cached, so every query must do a
> physical read. If you mainly do lookups on the primary key, BDB or
> InnoDB would probably be faster (they both cache index and data).
>
> Most of the pros and cons for each table type are listed in the manual.
>
> --
> Dan Nelson
> dnelson@stripped
>
> ---------------------------------------------------------------------
> 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 <mysql-thread87505@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-turner=tellme.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
