On Sat, Sep 01, 2001 at 11:42:52AM -0400, Jocelyn Bernier wrote:
> Hi everybody,
>
> I am currently looking the transactional part of MySQL and I'm
> wandering which one is best to use in regard to efficiency and
> reliability. Which one is the most stable, etc....?
While I have some of experience with InnoDB and very little experience
with BDB tables, here's my take on the situation...
BDB tables were/are a nice stepping stone for MySQL. They were the
first transactional table type. People who needed transactions (or
more fine-grained locking) use BDB, but a lot of folks were still
waiting for something like the more traditional systems (Oracle,
Sybase, SQL Server, etc). BDB tables do have a few odd qualities.
InnoDB performs very well but is newer. It seems to be quite stable
if you're not using BLOBs. However, I expect InnoDB to easily surpass
BDB in popularity, developer support, and features. For all I know,
it already has.
I see InnoDB as being one of the more viable MySQL table types for the
long-term.
You can probably build your application on BDB tables today and be
just fine. You can probably build your application on InnoDB today and
be just fine if you take backups and keep up to date with MySQL as any
InnoDB are fixed.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 33,371,656 queries (110/sec. avg)
---------------------------------------------------------------------
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
