subject:"\[PHP\] Speed up MySQL"

RE: [PHP] Speed up MySQL

2003-06-27 Thread Aaron Gould

: [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

[PHP] Speed up MySQL

2003-06-27 Thread Erich Kolb

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