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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 26, 2003 8:28 PM
Subject: [PHP-DB] Need some MySQL
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
On Friday 26 September 2003 22: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
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