Honestly, I think the general load issue is itself caused by PHP clearly running as a CGI instead of using the Apache module.
However, the time spent in MySQL is certainly the fact that generating that page is just taking too long doing too many queries. The only solution to that problem would be cutting down on the query count, and the nasty ones in particular...
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
