General Forum
Post count... 24 replies
so why has everyone's post counts dropped?
ex: i went from 1800+ to 300+.
Tbrown (Admin) said on: 05/17/07 12:13 am
(34 Minutes, 45 Seconds ago)
It was everyone. I was performing some unscheduled maintenance to improve server performance. FYI, I have archived forum posts older than about 8 months old...
So let it be written, so let it be done! -- Admin
(Tbrown (Admin) has posted: 3 forum posts)
User ID: 23 / Joined: 6/3/2002
(34 Minutes, 45 Seconds ago)
It was everyone. I was performing some unscheduled maintenance to improve server performance. FYI, I have archived forum posts older than about 8 months old...
So let it be written, so let it be done! -- Admin
(Tbrown (Admin) has posted: 3 forum posts)
User ID: 23 / Joined: 6/3/2002
2k to 400...
wow...
wow...
So THAT was why the server went down...
Sorry guys! We really need a better forum system *sigh*...
But I've gotta say, tarsonis and now truesource have been a great help and I really appreciate everything they've done for this site!
But I've gotta say, tarsonis and now truesource have been a great help and I really appreciate everything they've done for this site!
I lost over 2000 posts :P
LoL
Shows how much ive dropped of in posting recently :P
Oh well
Justtt a number
LoL
Shows how much ive dropped of in posting recently :P
Oh well
Justtt a number
OOoohhh, I should be in the double-digits, I would imagine.
[Added at 05/17/2007 04:42:57 by Elminster]
Damn! This very post made me double-digits.
I prefer the look and feel of this forum than to most forums I've visited.
Actually elm, post count isn't affected in General Forums.
You were double-digits. xD
You were double-digits. xD
and my post is..
I went from over 3.3k to 100 :P
I've dropped from 6000 in the past :P
So have i :)
Anyways tom, i actualy like this layout.
So if you do get a new fourm, try to get it somewhat like this layout.
Anyways tom, i actualy like this layout.
So if you do get a new fourm, try to get it somewhat like this layout.
3200 => 34
I kept like 10% of my posts... I was nearing my user-number.
play bnt!
/checks posts count
/checks posts count
Oh.
wow I post alot :P
I post like Baron
im the bomb diggity dog at posting yo
Why would post counts drop when you deleted/archived old posts?
(The following is from the biggest noob when it comes to databases).
That would, as far as I know, mean the post count was calculated from all the posts the user has made when a page with a post count is requested. Wouldn't it make better sense to use a simple increment system where the post count isn't really linked with the amount of posts a user has in the database?
(The following is from the biggest noob when it comes to databases).
That would, as far as I know, mean the post count was calculated from all the posts the user has made when a page with a post count is requested. Wouldn't it make better sense to use a simple increment system where the post count isn't really linked with the amount of posts a user has in the database?
(The following is from someone who has worked with databases for years now)
I don't think NN forums actually "calculate", every time a page requests a user's post count, the amount of posts this user has made since the last archiving. It would be way too tedious to go through the whole database and find every of his posts. Forums most probably use an auto increment system as you said. However, to keep the post count accurate, every time one or more posts are deleted, the code takes the ID of the user who had posted the concerned thread/reply and modifies his post count in the database consequently. That way, post counts remain accurate, even when posts are deleted/archived.
That said, when Tom purges the posts, he might do it directly from the database. If so, the code isn't run and can't adjust everybody's post count. That time, he can just run a script that will go through the whole database once to recalculate all the post counts. That done, the other system I described above takes the task over.
Hope my pedagogy was good enough and you understood what I explained.
Lesson 1 - Introduction to databases => Done.
Your almighty webmaster,
VoDkA
I don't think NN forums actually "calculate", every time a page requests a user's post count, the amount of posts this user has made since the last archiving. It would be way too tedious to go through the whole database and find every of his posts. Forums most probably use an auto increment system as you said. However, to keep the post count accurate, every time one or more posts are deleted, the code takes the ID of the user who had posted the concerned thread/reply and modifies his post count in the database consequently. That way, post counts remain accurate, even when posts are deleted/archived.
That said, when Tom purges the posts, he might do it directly from the database. If so, the code isn't run and can't adjust everybody's post count. That time, he can just run a script that will go through the whole database once to recalculate all the post counts. That done, the other system I described above takes the task over.
Hope my pedagogy was good enough and you understood what I explained.
Lesson 1 - Introduction to databases => Done.
Your almighty webmaster,
VoDkA
........Okay....
Voddy just OWNT somebody.. No joke. Vodka, this was too severe an ownage. I think this post needs to be deleted. Someone could have a traumatic experiences from this ownage.. O_O
Voddy just OWNT somebody.. No joke. Vodka, this was too severe an ownage. I think this post needs to be deleted. Someone could have a traumatic experiences from this ownage.. O_O
Vodka, assuming this forum is efficient =]
Duh, I should know that. I don't know why I posted that.:/