Usually myself and Kyle are working diligently in the background on the technical side of things, among other stuff, to make sure that this beast of a website continues to run smoothly. While we try to keep PbN as fast as possible we also like to make sure that you don't know when we're making changes, at least in terms of performance, because that generally means we just royally broke something. Erm, alright, I
generally royally break something. I thought I'd try something new and give you a better idea of one of the things that might come up during our duties.
Anyways, I had made a change earlier in the week to the way the threads listed in the BST forums are displayed due to a bug in the bump system and because of this we have been seeing a higher load on the master database server. I spent some time trying to better optimize the query that was causing the increase in load but it's already as good as it is going to get.
As you can see we are already moving older threads in the BST forums into another archive forum which does not have posting privileges. This helps to keep the queries running faster. So the only practical solution at this point is to automate the archiving process, which I have done. As it is currently setup, any BST thread with no posts newer than 4 months will go into it's BST Archive (if it has one). This will help their non-archive counterpart to fetch threads faster.
To give you an idea of just how much you guys are posting in the BST, after running the archiving script:
Threads moved: 203,054
Posts Moved: 2,602,272
It took about 25 seconds to select and update that amount of data.
Posts in the BST Archive: 14,926,355
Posts in the Live BST: 3,641,199
The BST itself contains 21,565,437 posts now (yes, that's over 21 million
), which is just under half
of all of the posts on PbNation. That should dispel the "majority" claims by the Small Talkers (sorry guys!).
Anywho, thought someone would enjoy that! I'm gonna go back to staring at graphs now! WWweeeeeeeeee.
Thanks for your support!