I am already running MySQL 4, how would I go about adding indexes? "Manuel Lemos" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > 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
