RE: [PHP] Speed up MySQL
| From: | Aaron Gould | Date: | Fri, 27 Jun 2003 20:00:16 +0000 |
| Subject: | RE: [PHP] Speed up MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-153206@lists.php.net to get a copy of this message | ||
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
agould@partscanada.com
-----Original Message-----
From: Erich Kolb [mailto:ekolb@randbreceivables.com]
Sent: June 27, 2003 3:56 PM
To: php-general@lists.php.net
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