On Mon, 29 Sep 2003, Michael Chaney wrote: .. > Regardless, the question ultimately comes to this: do you want a system > that has these features duct-taped to the side, or one that was > correctly designed from the start? That I have to use InnoDB or BDB > tables to get these features is, as far as I'm concerned, even more > evidence that MySQL isn't up to snuff and likely never will be.
According to MySQL, they support different table types so that if you want raw performance and a mostly-read environment, you use the standard setup. You use InnoDB if you want row-level locking and commit/rollback. Sounds reasonable to me. BUT: the row-level locking still has a ways to go. I wrote this bandwidth/traffic analyzer which logs to MySQL. With the default MyISAM table type, it would not work -- so much insert traffic, the read-only reports would never finish. InnoDB was better, but when the table size exceeded 10M rows it would choke too. Since Oracle wasn't an option for this project of mine, I just set up a cron job to truncate the tables every day. :P --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
