On Thu, 24 Oct 2002, Peter Zuidema wrote: > Please help, > We have big performance problems. > This is the situation: > > We haven an Windows NT server with a P355 processor and 256MB Ram. We have > installed version 3.49 of mysql > (we have also tried version 3.52). > > When we do a select on a table which contains about 10.000 records, we have > for about 10 seconds a cpu of 100%. > We use MyISAM tables and have checked indexes and we have checked if tables > need to be repaired. > > Is there someone who can give advise to get a better performance of mysql?
Probably someone may be able to help you as soon as you tell us what your SELECT query looks like and what the result of EXPLAIN SELECT is. Thomas --------------------------------------------------------------------- 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
