RE: table types

Can't speak for BDB other than what you've mentioned.  BDB, I believe was
the first table type to support transactions in MySQL but I don't see a lot
of people talking about them these days so I infer that there are not a lot
of people using them.

MyISAM is the default table type.  Use it if you need raw speed and will
never need any of the other features of a table type like InnoDB.

InnoDB is (IMHO) the best of the available table types. I've not
bench-marked them against MyISAM but I have run databases with both table
types. (Not at the same time)  I can't say that I've noticed a speed
difference.

Heikki is making great strides with InnoDB and I'm using 3.23.x in
production as well as 4.0.1 in development and both of them are stable for
day to day use. (NOTE: I'm not really pushing it hard. I don't use
replication or fulltext searching.)

Bottom line:
Use InnoDB unless you have a good reason not to.

=C=

*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*


-----Original Message-----
From: Mathieu DESPRIEE [mailto:mathieu.dot.despriee@xxxxxxxxxxxxxxxxx]
Sent: Friday, June 28, 2002 6:10 AM
To: MySQL ML
Subject: table types



Hi all,


What are the major differences between BDB and MyISAM separate the fact
that BDB is slower and suports transactions, and MyISAM faster and does
not support transactions ?
(On most recent version of MySQL 3.23)

What are the major avantages/drawbacks of InnoDB ?


Thanks





---------------------------------------------------------------------
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-thread113286@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
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-thread113302@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php