On 06/27/2003 04:55 PM, Erich Kolb wrote:
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!
Use the appropriate indexes and upgrade to MySQL 4 to benefit from query caching.
--
Regards, Manuel Lemos
Free ready to use OOP components written in PHP http://www.phpclasses.org/
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
