In my experience InnoDB tables are superior to BDB, but during my comparisons I was working with a lot more data -- millions of rows -- than you will be; BDB's problems seemed to center around the size of the tables. So, BDB could work well for you.
But, I can recommend InnoDB as a good way to go for your setup. Should work fine. --Walt Weaver Bozeman, Montana -----Original Message----- From: Aaron D. Turner [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:11 PM To: MySQL List Subject: BerkeleyDB or InnoDB? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've read the docs on mysql.com about the BDB and InnoDB table formats, as well as their pro's & con's and I was wondering if anyone could give their opinion on the matter. I don't need row-level locking or other fancy features other than transaction support. My tables are about 1-5 thousand rows for the forseeable future. It's also not a heavly loaded DB (about 1-5 users at a time). I'm mostly concerned about stability and reliability. I do nightly backups, but even loosing a few hours worth of work would be 'bad'. With this in mind, suggestions anyone? Thanks. - -- Aaron D. Turner Security Architect, OneSecure http://www.onesecure.com/ [EMAIL PROTECTED] work: 408-992-8045 cell: 408-314-9874 pub 1024D/1B57EB4D 2000-09-27 Aaron D. Turner <[EMAIL PROTECTED]> Key fingerprint = F90C BFB4 4404 5504 295D 4435 578B 1DD5 1B57 EB4D All emails by me are PGP signed; an invalid signature indicates a forgery. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Public key 0x1B57EB4D at: http://www.keyserver.net/en/ Filter: gpg4pine 4.1 (http://azzie.robotics.net) iEYEARECAAYFAjyWO+MACgkQV4sd1RtX601WXwCfRJUZQiF3gbN7JVxKBcKyX71t yJkAn0LLB32DVOWX1fqMIg+MeSEJJ/v6 =oL// -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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