Well, some is better than alot.
I'm seeing a few 25 second page loads, most seem within 3-6 seconds.
I've split log processing into 2 batches as the log files get rather large transfering 3+ gigs a day.
I'm going to do everything I can with this server. I can't afford to move to the next level up. This ones costing $255/month. Next server level is about $400/month.
Hmm...I remember that 'sleep' concept. Been a while.
A site at our size/traffic should be on a different configuration (bit technical, involves 3 servers) thats, well, outside our budget at the moment. I keep playing the lottery though.
Pretty much. We're doing about 80,000 pages and 3GB a day in traffic.
What we did so far is upgrade PHP, and put in a number of MySQL config changes, and a few other tweaks.
Huge database getting queried that much is gonna slow things, as is transferring that much data. Maybe reducing the amout of data that actually gets sent as well?
Or cutting back how many queries need to be run to display the slower pages? (Show less stuff) even the html file that gets created on the main forum page is 165kb, and that has to get rebuilt and resent everytime.... Sure raises pity for anyone still on dial up...
Database look ups.
Apache is hardly ticking at the moment.
Main forum page is a little graphically heavy, as well as text heavy. About the only 'bloat' graohically are sponsor banners. Lose those, lose the site. The text I might be able to save a few kb on, but the cost would be indexability on search engines. I'll be doing a detailed analysis of the logs in a few days, and trying to do some load-balancing on the more intensive sections.
Instead of navigating fromt he main page...probably saves some bandwidth...although that script i've got running that opens a new browser to the martial talk site every 30 seconds probably doesn't help.......
Other pages don't seem terribly slow, but loading up the main forum page always has some lag to it.
As for the MySQL, I'm assuming you've optimized all the tables? The server is stripped of all unneeded processes? (ex it isn't running "X" or anything else that shouldn't be there)
Maybe removing some of the unneeded queries, things like getting rid of the "Who's Online" on all pages except the "who's online" page.
If the banner ads are being pulled out of a database, or more likely the locations and links maybe get them out of there into a php file...
Damn... this thread probably has a high geekiness rating...