InnoDB COULD help if there's an issue with table locking and intense concurrent multi-user access. InnoDB's row level locking should help with this. Some queries will be faster with InnoDB and some will be slower. For instance, select count(*) from table_name will do a full table scan with InnoDB. Besides specific queries, the nature of the application may determine whether InnoDB speeds up overall performance. Intuitively I'm thinking concurrent, multi-user OLTP type apps will benefit. I'm getting ready to do some benchmarking on a particular app and I think its necessary before drawing any conclusions.
IMHO, Steve Orr -----Original Message----- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:39 PM To: Chris Boget; [EMAIL PROTECTED] Subject: RE: MyISAM v. InnoDB switching to InnoDB won't help. Take a look at optimizing your queries. Are you using LIKE? have you looked at the output of EXPLAIN? =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Chris Boget [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 1:53 PM To: [EMAIL PROTECTED] Subject: MyISAM v. InnoDB When dealing with a considerable number of records (10s of thousands) in a particular table, which is better to use? Currently we are using MyISAM and the queries on those tables are kind of slow. I've set the most frequently used (in a query) columns as keys and that isn't speeding it up any. I'm wondering if switching to InnoDB might solve my problem? 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 --------------------------------------------------------------------- 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
