According to Sams Publishing (April 2002):
    The Berkeley DB table type is a usable, transaction-safe table type, but it
is not the most optimized table type in the mix.  BDB tables support the basic
elements of transactions as well as the AUTOCOMMIT variable, but are not as
popular or as developed as the InnoDB or Gemini table types.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


----- Original Message -----
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 12 June, 2003 02:19
Subject: BDB or InnoDB


Hi MySQL Fans,

I am sure this question was asked before, but I did not find sufficient info,
so please allow me to ask this question again.

When comparing BDB and InnoDB which one would be (generally speaking) a better
choice for a certain purpose ?

I understood that BDB and InnoDB have basically similar features.

Except BDB uses-page-level locking and InnoDB uses row-level-locking.

There are some things which I am not so sure about.

Does BDB support foreign keys ?

Any response much appreciated. I searched through the archive back to June
2002 and in the info manual , but unfortunately I did not find what I was
looking for.

Did  I miss something ?


--
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to