Users Pruned

[Dyntheos]

197 former members in the Banned Category had thier accounts deleted.

1195 Users were deleted who do not understand how email works and thus never got thier accounts working in the first place.

8466 Registered users were deleted who have under 100 posts and haven't visited the forum in 90 days.

193 Registered users were deleted who have under 1000 posts ( 95% had 200-300 posts ) and haven't visited the forum in 180 days.

2 Developers that haven't visited the forums in 700 days were deleted.

1 Random member was deleted just because I like to be evil..

[SACSlym]

Hmmmm i wonder who the random was. :dyn:

Also though, did the pruning take into account that members who have invisible mode on don't officially record what their last logon date was?

[[Vertigo]]

I wonder who that random member was that got deleted... I hope it wasn't me.

[Random Person]

It's not me!

I'm still here.

Who was the Random member to be deleted it?

Edit:

HOLY SHIT! That's half the damn board.

[bloodthirster2]

you should change the title to "users pwnd" it sounds the same to me

i was going to say a random person was deleted but he posted so its ok

[General Nuke Em]

2 Developers that haven't visited the forums in 700 days were deleted.

Devs get deleted from their own forums? 0_o

[Homdax]

Forums arent theirs anyway.

Ahh, so thats why I have a slight perfomance improvement browsing Forums...

[Aquila]

... we're gonna need a bigger graveyard.

[EarthBorn]

The forums run *almost* as good as before.
BTW,
Is this the biggest user "pruning" in RB history?

[Void]

An we were hitting the 20k users mark... :/....so sad

[Homdax]

EartBorn:
Thats nothing, look here: http://forums.relicnews.com/showthread.php?t=39509

/me Luffs digs in forums

[Moe]

Guys, I don't think this is going to speed up the forums. All the deleted accounts belonged to people who hadn't visited the forums in at least 90 days - so they never contribute to the traffic increase to begin with.

[Druidika]

Less users = smaller Users table = higher MySQL performance

That's how I think it works.

[Retroboy]

Druidika - not a whole lot really, for two reasons. First, the vast majority of the work associated with the data flows to and from the server's SQL tables involve content from threads, not the user table. Second, there are only about a dozen data items that come with each user whenever a retrieval query runs - user # (yours is 17168 - hover over your name and view the hyperlink to see it), user name, mini-sig, avatar location, join date, location, postcount, banner/sig (and there aren't really a whole lot of those), and the various symbols representing MSMessenger, ICQ, Yahoo!, etc. Of these, the biggest is the avatar or the sig, but I think the former is stored externally to the database anyway and so doesn't impact performance.

You might get some small savings if the overall user table is now so small that it can stay 100% resident in memory, but that's still small potatoes compared to the thread content data exchange requirements, and seek-time is minimal because it's keyed on user number.

-- Retro, ex-database admin, data structure performance designer, and IT trainer.

[ÜberJumper]

Avatars are stored locally, signature images stored remotely.

[Chaos_Smurf]

DARN i thought id be the random... seriously it was expected...

anyway...

That is an awful lot of members... shouldnt there be an auto-delete for any members that dont know how e-mail works?

[General Blaze]

/me checks body

It's not me, that's for sure.

Damn, a four day vacation in Sydney and look what happens.

[Starblade]

I post, but no one can see the posts. Hello? Hello?! ONOES!

[Fiirks]

I wish i could take a four day vacation to Sydney!

Is it me or have hte forums been improving over the past couple of days?

I turned off all the avatars and sigs and stuff and put on the minimal skin, hopefully other people will help conserve bandwidth.

Has DOW slowed down at all?

[Comrinec]

197 former members in the Banned Category had thier accounts deleted.

1195 Users were deleted who do not understand how email works and thus never got thier accounts working in the first place.

8466 Registered users were deleted who have under 100 posts and haven't visited the forum in 90 days.

193 Registered users were deleted who have under 1000 posts ( 95% had 200-300 posts ) and haven't visited the forum in 180 days.

2 Developers that haven't visited the forums in 700 days were deleted.

1 Random member was deleted just because I like to be evil..

Ive found on quite a few forums, emails dont actually arrive when you register for various reasons, if 5% of the total registered users failed to start their accounts I would consider checking the mail server for problems.

[Moe]

The mail server is fine, I use it on a daily basis. A few email providers appear to be paranoid though and put relicnews.com on their spam lists, so the activation e-mail gets moved into some anti-spam folder and gets lost amidst all the viagra ads.

[BrianGeneral]

Well, there're more members got deleted than I originally think of...... Most likely, those "register for DoW then gone" guys, right?

ps. Glad that it isn't me who got deleted

[Mr.Popo]

Aw, Dyn. You're like a big cuddly teddy bear. Only a teddy bear with admin priveleges and a penchant for teh ban stick, but I still think you need a hug.

[Trizzdog]

Now only if the random person was a senior member... that'll show 'em! :cranky:

/me uses over-sized smilie and then hides behind his

[Merturk_NB]

someone save Mr. Popo

his posts are so sad now

[Ruzdreg]

So your account will get removed if you don't post regually?


Uh oh, better start making rabdom posts if I have nothing to talk about.:vikingb:

[Homdax]

Not if you "dont post regularly" but if You dont post in 3 months. Just like Hotmail, I think.

[cfoley]

It's more a case of if you don't log in. That's all you have to do.

I also don't think that the deletion is automatic or as regular as the rules say, hence the existance of this thread.

[ionfish]

Activity is measured by how recently you logged into your account, not how recently you posted. Lurkers are safe.

[Mr.Popo]

someone save Mr. Popo

his posts are so sad now

No kidding. Just look at my sig

[Handarazuur]

Yes, but what does twinkies have to do with anything?

[Mr.Popo]

The other part. Cockwinky's deserve their own topic altogether.