Forever Changing Post Counts


Recommended Posts

Steven P.    17,422

Hi, some members may of noticed their post count (including my own) dropped, in some cases (like mine) its 100's. This is because we have just purged comments from our database.

In total we deleted about 35,000 comments and 45,000 poll votes to clean up and speed up our sql database.

For future reference we *can* disable post counts on comments all together so that this doesnt happen again. Forum posts have been unaffected by all of this.

Our server can cope with everything but we do need to streamline everything as best as possible and this was done by reading and following up on this at the mysql website:

One of the most basic optimisation is to get your data (and indexes) to take as little space on the disk (and in memory) as possible. This can give huge improvements because disk reads are faster and normally less main memory will be used. Indexing also takes less resources if done on smaller columns.

So we hope you understand.

Link to post
Share on other sites
tomwarren    68

Yeh nevermind :) I lost 400 but hey life goes on lol

Link to post
Share on other sites
uniacid    0

ah thx for explaining neo, I was wondering what happened to my 40 other posts :/ o well

Link to post
Share on other sites
Malechai    120

NNNNNNNOoooooooooOOOOOOOOOOooooooooooooo :huh: :wacko:

coolies ;)

Link to post
Share on other sites
abysal    98

:o Well I'm glad I did a search about "post counts" like every one always says to do a search before posting your own topic and only to get yelled at later becuase it's answered in another post :o

Link to post
Share on other sites
Tim Dorr    0

good idea. I think we can't part with the flames that litter the mozilla release news posts :D

Link to post
Share on other sites
Dreamer    0

A good decision. Do you already feel a difference? I ask because you can see the server load instead of me :)

It'll take some time to me to notice :)

Link to post
Share on other sites
Electronic Punk    7

Neobond: Does this really help? We hae never purged old posts or comments...

Our database is 200 megs at the moment.

Link to post
Share on other sites
Toxikk    0

i cant even remember how many i lost or even how many i have now... :o

Link to post
Share on other sites
Tim Dorr    0
Neobond: Does this really help? We hae never purged old posts or comments...

Our database is 200 megs at the moment.

Well, our forum db is 200 meg or so, but that's irrelevant. The reason it's such a big deal is the number of records needed for indexing and selecting. Having to search through a thousand versus a few hudred thousand records to build a page is a lot better :)

Link to post
Share on other sites
shockz    8,189
Neobond: Does this really help? We hae never purged old posts or comments...

Our database is 200 megs at the moment.

Actually they have pruged old comments before. I think last year they did it.

lol... i'm never going to get to 2000

First there was the post recount... before that I had 1810's... after the recount I was down into the 1690's, I got it back up to 1743.. and now I'm back down to 1600's... lol. :cry: :D

Link to post
Share on other sites
Greenmuncher    0

lol i was just about at 300... i lost 20 or so... ahh well just need to go on a spaming spree.. jk :x

Link to post
Share on other sites
Mr magoo    1

2100 > 1400.

:( :(:( :(:( :(:( :(:( :(:( :(:( :(:( :(

Link to post
Share on other sites
RadishTM    318

I lost a few :( ....

But if it helps Neowin, ahh, what the hell :D ....

Radish.

Link to post
Share on other sites
sphere    0

well we can make them all up in this thread again :D

Link to post
Share on other sites
cheekymonkey    0

With a miniscule post count that would get me right embarassed in the Neowin showers I reckon this forum cold water ain't gonna affect me much :D

Good job I don't think that post count and 1337ness ain't inextricably linked really.

Link to post
Share on other sites
DWZ    0

I guess I will need to go spam now

j/k

Link to post
Share on other sites
nl|nighthawk    0

I feel bad for that member whos walking around with like a -45 post count.. lmao

:D

Link to post
Share on other sites
Steven    80

i lost over 600, i'm not a happy camper..

i've already had 2 3,000 post threads :x

:cry:

Link to post
Share on other sites
shockz    8,189
i lost about 1000, i'm not a happy camper..

i've already had 2 3,000 post threads :x

:cry:

lol... i know how you feel. I get so close to 2000, like 200 posts away... and then I'm back down to 1600. :(

I mean post count isn't everything... but its still cool to have. ;)

Link to post
Share on other sites
Joseph Zollo    6

Eh, no biggie, I really never liked post counts in the first place. I go for quality, not quantity.

Link to post
Share on other sites
Jerichohol    1
I feel bad for that member whos walking around with like a -45 post count.. lmao

:D

LMAO :D

I know, is that a first for neowin?

Link to post
Share on other sites
Xcalibur    0

hehe.. i lost a bunch.. but now I can be 1337 again with the 1337th post!

Link to post
Share on other sites
Tim Dorr    0
hehe.. i lost a bunch.. but now I can be 1337 again with the 1337th post!

Don't make me warn you... :D

Link to post
Share on other sites
Silvorgold    1

well if its to save space..do whatever u want :p

feel free to do whatever the heck u want to X...he gets any everyones nerves from time to time :p

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.