Re: Need some MySQL Optimization suggestions - uber slow queries
| From: | Cory Hicks | Date: | Fri, 26 Sep 2003 22:44:21 +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-30727@lists.php.net to get a copy of this message | ||
Matt,
Have you tried an EXPLAIN query yet? Start with this and send the result
of the query back to the list...that would give everyone a better sense
of what is happening.
Cory
On Fri, 2003-09-26 at 09:58, Matt Babineau wrote:
> 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
--
Cory Hicks <chicks@tri-intl.com>
TRI International