It all depends if you need to use transactions. If you are entering items from a cart into a database you may want to use transactions to make sure ALL items get written correctly before you actually commit the changes to the database. With InnoDB tables you can use transactions so if one or all insert statements in a loop didn't work you could rollback the changes or if they all worked, you would commit the changes to the database. You can't use transactions with MyIsam.
-Steve. -----Original Message----- From: Konstantin Yotov [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 7:29 AM To: [EMAIL PROTECTED] Subject: InnoDB or MyIsam? Hello! :) I'm wondering which table type is better and why for web project with about 100 000 customers. May be InnoDB gives better query performance? I'm using now MyIsam, but is this better idea to move to InnoDB? Thank you! :) __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com --------------------------------------------------------------------- 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
