Been getting the occasional warning on one of our client sites about excessive CPU usage and/or slow MySQL queries. Looking at the logs, it looks like it's more the latter (slow queries). Some of the queries involve some joins, etc. But nothing too crazy, and there are the standard indexes on most of the relevant columns used in join/where clauses. Everything Joomla 1.5 does when it does it's initial setup. I've done everything the web host recommends and the last thing they said to check the PHP code and try to optimize that a bit. But it's standard Joomla 1.5 stuff. They claim they don't have any other clients having problems with Joomla 1.5. In the end, I think this is a problem with their MySQL server or their server in general, but they won't admit to that. So forgive me if this is more of a MySQL issue and not so much PHP-DB related, but it's the PHP side that is the last thing they're recommending I check that I technically haven't because I think Joomla's probably fine. As an example of a query that showed up on the log recently: UPDATE jos_content SET hits = ( hits + 1 ) WHERE id='123' The log says this took 7 seconds. There's an index on "id". There are only 400 or so records in the whole table. It's not like there are a million records and no index. Is there ANY rational reason this query would EVER take 7 seconds to execute? Any info/thoughts/advice would be appreciated. I know my way around a database or two and know a few things about optimization, but I need some solid evidence to throw at this web host so they'll listen to me. They're usually really awesome, but this case is causing me to lose my hair. Thanks in advance! -TG -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
