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