Re: [PHP-DB] Need some MySQL Optimization suggestions - uber slow queries
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 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
[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
Re: [PHP-DB] Need some MySQL Optimization suggestions - uber slow queries
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 negligible. Does anyone have any suggestions for speeding up the query process...a lot? Try asking on the mysql list? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* There is no grief which time does not lessen and soften. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need some MySQL Optimization suggestions - uber slow queries
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 [EMAIL PROTECTED] TRI International -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php