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: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
