On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote: > > 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.
Really? That's not a lot of data. Can you provide examples? > 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? Probably won't help much at all. We need to find the root of the problem (why the queries are slow). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 46 days, processed 1,002,132,916 queries (247/sec. avg) --------------------------------------------------------------------- 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