Hi Chris, Welcome to the MySQL list;^) good to see you here... Any way I found a link which might explain why your InnoDB inserts take longer, perhaps this may be the reason...
http://www.mysql.com/doc/S/E/SEC418.html "In inserts InnoDB uses the insert buffer to merge secondary index records to indexes in batches. That saves a lot of disk i/o. In rollback no such mechanism is used, and the rollback can take 30 times longer than the insertion." hth Norman -----Original Message----- From: Chris Withers [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 12:42 PM To: [EMAIL PROTECTED] Subject: InnoDB inserts: HELP! :-) Okay, second time of asking, does anyone know why InnoDB inserts are an order of magnitude slower than BDB inserts? Is this true only for me? If so, what am I doing wrong? Is it a FAQ? If so, where can I find the answer? Are InnoDB tables supposed to behave like this? If so, why? I know I'm new here so I might be missing something, please let me know what it is! cheers, Chris --------------------------------------------------------------------- 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