01-09-2012, 07:23 PM
Join Date: Mar 2007
Originally Posted by Rob Williams
As our user count on the forums inched closer to 10,000, I had to do something to bring the number back down. No, it's not that I don't want lots of users on our forums; it's just that I wish more than 20% of them were legit users. To help clean things up, I removed all users who signed up but never activated their accounts, and also those who have never posted (or are spammers). Some stats:
Total Members: 9,971
Database Size: 390.6MB
SQL Records: 206,382
Total Members: 2,651
Database Size: 375.8MB
SQL Records: 178,833
The users that were deleted consisted of:
Users with 0 Post Count: 5,297
Users Awaiting Confirmation: 2,024
No regular user should have been affected by this, but if you are in some way, let me know.
Wow, I wish they were all legit users! At least you save a lot of space and cut down on the spam.