Find fields & stores near you!
Find fields and stores
PbNation News
PbNation News
Community Focus
Community Focus

Thread Tools
Old 07-11-2008, 06:43 AM #1
Tony's Avatar
Join Date: Feb 2001
Annual Supporting Member
 has been a member for 10 years
BST Archiving Fun for the Technical Win

Hello All,

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!
Tony Rieker
PbNation Co-Founder
Tony is offline   Reply With Quote
Old Sponsored Links Remove Advertisement
Old 07-11-2008, 07:40 AM #2
Rockin' Cocks
chillinspyder2's Avatar
Join Date: Sep 2006
Location: Virginia
 has been a member for 10 years
Those are some pretty amazing facts
chillinspyder2 is offline   Reply With Quote
Old 07-11-2008, 12:01 PM #3
Chris631's Avatar
Join Date: Jun 2007
Location: NE
Chris631 donated to help Peyton Trent
Chris631 supports Team VICIOUS
Chris631 supports our troops
Chris631 has achieved Level 3 in PbNation Pursuit
Originally Posted by chillinspyder2 View Post
Those are some pretty amazing facts

well i guess the us small talkers will have to up our post count now
Just a small town girl....
TheMike-No way, dude.
Look how gangster he looks with that lean back, slightly closed eyes, shaggy hair at a formal event and a ****ty tie. OG Triple OG right there.

ST- The Taylor Swift Thread: She makes our hearts melt!!
Livin' in a lonely world....
She took the midnight train goin' anywhere
Chris631 is offline   Reply With Quote
Old 07-12-2008, 04:03 PM #4
texaspaintballplpaye's Avatar
Join Date: Feb 2004
Location: Dallas, TX
texaspaintballplpaye is a Supporting Member
 has been a member for 10 years
texaspaintballplpaye is a Paintball photographer
ST got owned. Now Nuke it!
texaspaintballplpaye is offline   Reply With Quote
Old 07-12-2008, 11:41 PM #5
SpyderPB819's Avatar
Join Date: Feb 2007
Location: Charlotte
 has been a member for 10 years
SpyderPB819 donated to help Peyton Trent
Pics of graphs or shens.
SpyderPB819 is offline   Reply With Quote
Old 07-13-2008, 08:27 PM #6
Payson Hotshots
Igotaevo's Avatar
Join Date: Mar 2007
Location: Tempe, Arizona
 has been a member for 10 years
Igotaevo plays in the PSP
Igotaevo owns a Planet Eclipse Lv1
Igotaevo supports Empire
nuke st...
Igotaevo is offline   Reply With Quote
Old 08-23-2008, 08:10 PM #7
Pope_of_Dope's Avatar
Join Date: Aug 2008
Wow i would have never guessed there was that much b/s/t on this site.....good lord..
"From the womb, to the tomb, Wutang for life."

- ODB R.I.P.
Pope_of_Dope is offline   Reply With Quote
Old 08-25-2008, 01:33 AM #8
paintball_KIA4's Avatar
Join Date: Mar 2006
Location: Ohio
 has been a member for 10 years
Haha, what percentage of posts come from ST and it's sub-forums? I would say almost 1/3.

madgoat: "holy crap that got confusing. I was all "wtf, no girl is cool enough to have kimjung is boss as their xbl tag". I was about to ask if you were a dike or born male raised female. Come to find out it was a simple misunderstanding."

paintball_KIA4 is offline   Reply With Quote

Thread Tools

Posting Rules
Forum Jump