View Single Post
Old 08-24-2011, 06:24 PM   #1
Rob Williams
Rob Williams's Avatar
Join Date: Jan 2005
Location: Atlantic Canada
Posts: 13,366
Default Forum user purging

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:

Before Purge

Total Members: 9,971
Database Size: 390.6MB
SQL Records: 206,382

After Purge

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.
Intel Core i7-3960X, GIGABYTE G1.Assassin 2, Kingston 16GB DDR3-2133, NVIDIA GeForce GTX 770 2GB
Kingston HyperX 3K 240GB SSD (OS, Apps), WD VR 1TB (Games), Corsair 1000HX, Corsair H70 Cooler
Corsair 800D, Dell 2408WFP 24", ASUS Xonar Essence STX, Gentoo (KDE 4.11. 3.12 Kernel)

"Take care to get what you like, or you will be forced to like what you get!" - H.P. Baxxter
<Toad772> I don't always drink alcohol, but when I do, I take it too far.

Rob Williams is offline   Reply With Quote