Re: Need some MySQL Optimization suggestions - uber slow queries
| From: | Nitin | Date: | Sat, 27 Sep 2003 07:57:00 +0000 |
| Subject: | Re: Need some MySQL Optimization suggestions - uber slow queries | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30729@lists.php.net to get a copy of this message | ||
try implementing Query cache, which comes with MySQL v 4.0 n above.
http://www.mysql.com/doc/en/Query_Cache.html
enjoy
Nitin
----- Original Message -----
From: "Matt Babineau" <matt@criticalcode.com>
To: <php-db@lists.php.net>
Sent: Friday, September 26, 2003 8:28 PM
Subject: [PHP-DB] Need some MySQL Optimization suggestions - uber slow
queries
> I have a page that when all said and done is super slow. The queries are
> running a bunch of JOINs and SORTs and WHEREs. I recently implemented
> the my-large.cnf file in hopes it would help out the situation, but the
> change appears negligible.
>
> Does anyone have any suggestions for speeding up the query process...a
> lot?
>
> Thanks, Matt
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>