Page 1 of 1

ADMINS - radical proposition :)

Posted: Tue May 03, 2005 5:33 pm
by Calimero
Just kidding !

Here is the situtation:

I looked at the list of members - to find "me self" in da list.

I found me, but also found some very usefull data related to maintenance of the forums.

I looked at how many posts users have.

And come up with these numbers:

0 posts = 5007 users;
1 post = 3091 users;
2 posts = 2044 users;
3 posts = 1008 users;
...

( you guess I did this over the browser not with mysql group by function :) )

So just to ask - have you ever though of deleting those users that havent posted anything for let's say 1 year, and have less than 5 posts.

I know that your (user) statistics would suffer greatly, but it would leave only those that are somewhat active on the forum.

What's your "official" :) oppinion.

Posted: Tue May 03, 2005 5:38 pm
by The Monkey
Why?

There's like, less than 2 megs of data there. Maybe less than a meg.

...

Posted: Tue May 03, 2005 5:41 pm
by Calimero
d'know, but as I study management - to me this looks like - as a principle - total waste of resources and mis-representation.

I like to keep things strait, and clear.

Re: ...

Posted: Tue May 03, 2005 6:46 pm
by hawleyjr
Calimero wrote:total waste of resources and mis-representation.
Not really. Those are legitimate users; posts or not & 2 Megs of data is not much at all.

IMHO ~ removing those users would be a waste of time.

Posted: Tue May 03, 2005 8:54 pm
by Roja
Also keep in mind that it makes things harder on users that signed up, but haven't posted.

By being logged in, you can easily seee when posts have changed ("View posts since last visit"), which you can't do without an account.

The forums should do everything possible to encourage people to visit, post, and return. The minor inconvenience of a few extra results in a search of users is trivial in comparison to that goal.

...

Posted: Wed May 04, 2005 12:13 am
by Calimero
IMHO ~ removing those users would be a waste of time.
simple query that looks like: DELETE FROM users, posts WHERE num_of_posts < 3 and date_of_last_post < 1 year ago; could do wonders.


By being logged in, you can easily seee when posts have changed ("View posts since last visit"), which you can't do without an account.
How many posts will be unread ( and checked ) from my last visit from let's say april 2004.


And just too add - do you even remember your username and password from a place where you havent even posted, or maybe just asked one question, and from then you havent returned.

This would logicaly lead that that user, although legaly registered can be considered totaly inactive, and therefore will not bring any value or publicity to the site - in any significant level.

Personaly, if I've visited here last year in march, I might try to remember the user and pass, but as the process of reg. is so easily and speedily finished, I would probably reg, again and ask one more simple Q.

Got my, point; Users would probably even accept that if you don't see them in one year, and they did nothing on your site that they could be subject to some prunning.


My goal is not to temper with the site's DB, just to see why is this (dead) pool of users considered an asset, instead as to be written off.

But never the less, its usefull to share ideas and practises with others.

Posted: Wed May 04, 2005 4:58 am
by patrikG
We've had this discussion before:

viewtopic.php?t=16594#80832