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]