I have just re-enabled the old thread view updates. Updates on views are still kept in another location, I just have to take them and add them to the rest. Sometime next week you'll see views just increase one day, that is why.

Thanks for all the hard work

Nice,well tuned website, Sir!

Thanks for getting all this sorted out. Now that you have most of the baseline work done, it is easier to track and see what hardware upgrades are required, if any. It does make phish frying faster!

Thank you for speedy interface(s). I actually enjoy the work! (I am crazy, many on nuclear subs made me that way along with some interesting genetics.)

Test performed from: Seattle, WA
Test performed at: 2008-02-23 23:12:12 (GMT -05:00)
Response Time: 1.834 sec
DNS: 0.425 sec
Connect: 0.263 sec
Redirect: 0.000 sec
First byte: 0.363 sec
Last byte: 0.783 sec
Size: 39485 bytes

((((())))
Mad_Dog

109ppm 3.257s (2.519s)

We're not out of the woods yet - but definitely much better.

_________________
Bill (AFE7Ret)
Freedom is NOT Free!

Great first byte time.

It is the the "time to retrieve the first byte of data from the web server" via AlertSite. www.alertsite.com used to have a free trial, but apparently they removed it. Now one must sign-up.

I've seen the time to retrieve the first byte of data often take longer than subsequent bytes.

The website is running a lot better than before. Glad to see such nice tips, tricks and discussions. Thank you for sharing this I am sure there are a lot of learnings out of this experience. I am curious to see a list of things that helped with the performance and a list of things that didn't or made things worse. I also see that you went through the code and fixed/changed some things.

If I can still add my five cents in from a developer perspective there's still one trick that I use and it's always up my sleeve.

The trick is simple. First of all I install eaccelerator and set a pretty decent shared memory size segment. I also set it as the default for sessions instead of files (no disk i/o). Does phpBB use sessions? Does it store them in MySQL? (I ask because there's a setting in SMF to do that) And the second part is taking the queries that run against the database and caching the results in eaccelerator for a specific amount of time. Most of the queries are read-only and don't need to show live numbers so they could be cached in shared memory. Less queries running against mysql the quicker the pages load the less work mysql needs to do.

Here is the link to eaccelerator API: http://bart.eaccelerator.net/doc/phpdoc/

If you are using APC then it also has it's own very similar API interface: http://si2.php.net/manual/en/ref.apc.php

Gena01

The "silver bullet" as it were was to migrate mysql to another system. It appears as if the controller card is bad, so we'll replace it hopefully this week and monitor performance.

So we don't have a defintive answer yet.

Thank you for all the time you are spending on the rehab of the site.