Steven P. Administrators Posted November 11, 2002 Administrators Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/ Share on other sites More sharing options...
tomwarren Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 Yeh nevermind :) I lost 400 but hey life goes on lol Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499517 Share on other sites More sharing options...
uniacid Posted November 11, 2002 Share Posted November 11, 2002 ah thx for explaining neo, I was wondering what happened to my 40 other posts :/ o well Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499585 Share on other sites More sharing options...
Spyder Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 NNNNNNNOoooooooooOOOOOOOOOOooooooooooooo :huh: :wacko: coolies ;) Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499603 Share on other sites More sharing options...
abysal Posted November 11, 2002 Share Posted November 11, 2002 :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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499649 Share on other sites More sharing options...
Tim Dorr Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 good idea. I think we can't part with the flames that litter the mozilla release news posts :D Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499661 Share on other sites More sharing options...
Dreamer Posted November 11, 2002 Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499800 Share on other sites More sharing options...
Electronic Punk Posted November 11, 2002 Share Posted November 11, 2002 Neobond: Does this really help? We hae never purged old posts or comments... Our database is 200 megs at the moment. Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499813 Share on other sites More sharing options...
Toxikk Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 i cant even remember how many i lost or even how many i have now... :o Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499886 Share on other sites More sharing options...
Tim Dorr Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-499895 Share on other sites More sharing options...
shockz Posted November 11, 2002 Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500035 Share on other sites More sharing options...
Greenmuncher Posted November 11, 2002 Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500063 Share on other sites More sharing options...
john smith 1924 Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 2100 > 1400. :( :(:( :(:( :(:( :(:( :(:( :(:( :(:( :( Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500072 Share on other sites More sharing options...
RadishTM Veteran Posted November 11, 2002 Veteran Share Posted November 11, 2002 I lost a few :( .... But if it helps Neowin, ahh, what the hell :D .... Radish. Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500101 Share on other sites More sharing options...
sphere Posted November 11, 2002 Share Posted November 11, 2002 well we can make them all up in this thread again :D Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500103 Share on other sites More sharing options...
cheekymonkey Posted November 11, 2002 Share Posted November 11, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500105 Share on other sites More sharing options...
DWZ Posted November 11, 2002 Share Posted November 11, 2002 I guess I will need to go spam now j/k Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500283 Share on other sites More sharing options...
nl|nighthawk Posted November 12, 2002 Share Posted November 12, 2002 I feel bad for that member whos walking around with like a -45 post count.. lmao :D Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500313 Share on other sites More sharing options...
Steven Posted November 12, 2002 Share Posted November 12, 2002 i lost over 600, i'm not a happy camper.. i've already had 2 3,000 post threads :x :cry: Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500601 Share on other sites More sharing options...
shockz Posted November 12, 2002 Share Posted November 12, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500612 Share on other sites More sharing options...
Joseph Zollo Posted November 12, 2002 Share Posted November 12, 2002 Eh, no biggie, I really never liked post counts in the first place. I go for quality, not quantity. Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500647 Share on other sites More sharing options...
Jerichohol Posted November 12, 2002 Share Posted November 12, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500664 Share on other sites More sharing options...
Xcalibur Posted November 12, 2002 Share Posted November 12, 2002 hehe.. i lost a bunch.. but now I can be 1337 again with the 1337th post! Link to comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500672 Share on other sites More sharing options...
Tim Dorr Veteran Posted November 12, 2002 Veteran Share Posted November 12, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500735 Share on other sites More sharing options...
Silvorgold Posted November 12, 2002 Share Posted November 12, 2002 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 comment https://www.neowin.net/forum/topic/49729-forever-changing-post-counts/#findComment-500782 Share on other sites More sharing options...
Recommended Posts