Re: Speed up MySQL
| From: | Manuel Lemos | Date: | Fri, 27 Jun 2003 19:57:03 +0000 |
| Subject: | Re: Speed up MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-153205@lists.php.net to get a copy of this message | ||
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/