post count

  • We are currently upgrading MFK. thanks! -neo

aramirez8689

Jack Dempsey
MFK Member
Jan 19, 2010
80
0
36
st charles il
not that it matters but has anyone else every notice there post count go down mine went down 2 today not that it is a big deal just wanted to see what my next level was haha j/k just curious
 
post count, and your total posts on the site arnt physically linked.

To call your "post count" the sql database would need to read threw EVERY post and tally them up, imagine if you had a few thousand? and then a few other people posted in the same thread? that'd be one hell of a hit on the sql database...so when you make a post, it adds "1" to your "total_post_count"

if you make a thread in a forum where post counts is +1, and the thread gets moved into a place where post counts arnt increased you'll still have old post count + 1.

Now and then, the server recalculates users posts, when it finds out your thread was moved...it sees that you arnt "credited" for that post like you were before.
 
TheRealAndyCook;4810928; said:
post count, and your total posts on the site arnt physically linked.

To call your "post count" the sql database would need to read threw EVERY post and tally them up, imagine if you had a few thousand? and then a few other people posted in the same thread? that'd be one hell of a hit on the sql database...so when you make a post, it adds "1" to your "total_post_count"

if you make a thread in a forum where post counts is +1, and the thread gets moved into a place where post counts arnt increased you'll still have old post count + 1.

Now and then, the server recalculates users posts, when it finds out your thread was moved...it sees that you arnt "credited" for that post like you were before.

Nice post! I kind of have something to add.

I agree that a user's post will go up 1, per post they make in a region that accounts their posts for their "post count". This action should, and I am pretty sure has its own script, that applys with each user on this forum. When they post. So at this point when you have 1000+ users the DB will allready be accessed and used, almost constantly. Meaning the memory used will always fluxuate based on the amount of posts made per second or minute. So memory usage or the "hit" that the host takes will not remain constant and should in our case increase as our community grows. A reason why the host is upgraded every once in a while.

=]

Posted on mobile.monsterfishkeepers.com
 
MonsterFishKeepers.com