Speed up MySQL
| From: | Erich Kolb | Date: | Fri, 27 Jun 2003 19:55:43 +0000 |
| Subject: | Speed up MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-153204@lists.php.net to get a copy of this message | ||
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!