Read these mysql.com doc pages: http://www.mysql.com/doc/en/MySQL_indexes.html http://www.mysql.com/doc/en/CREATE_INDEX.html
-- Aaron Gould Web Developer Parts Canada [EMAIL PROTECTED] -----Original Message----- From: Erich Kolb [mailto:[EMAIL PROTECTED] Sent: June 27, 2003 3:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Speed up MySQL Can anyone offer some suggestions as to how I can speed up MySQL query results? I have a simple database with 3 fields in 1 table. The thing is that there are over 11 million records. Average query time is about 25 seconds. The machine itself is pretty fast(P4 1.8ghz/ 1gb ram). Any suggestions would be great! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php