Pruning users - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: General (/forumdisplay.php?fid=11)
+---- Forum: Forum & Website (/forumdisplay.php?fid=13)
+----- Thread: Pruning users (/showthread.php?tid=19513)
Pruning users by WDZ on 12-19-2003 at 03:41 PM
I'm about to delete 26% of the registered users on this board. Any objections? 
The following conditions must be true in order to be deleted:
1) The user has never made a post.
2) The user has not logged in after March 2003.
Advantages of pruning:
1) Less wasted space in the database and on the member list.
2) More usernames available.
3) Possibly better database performance with less records to keep track of.
Disadvantages:
1) Of course, accounts will be deleted. If one of the deleted members actually remembers these forums, and even remembers their password, they will have trouble logging in. 
2) The number of total users will go from 28000 to around 20000. I could work around that by making sure the number of deleted users is always added to the total, if you think that's a good idea. I don't really care about showing off how many users we have, but maybe you do.
RE: Pruning users by Choli on 12-19-2003 at 03:48 PM
quote:None, I agree, but it would be a good idea to send a mail to those users saying about that.
Originally posted by WDZ
Any objections?
quote:why that month? better a more recent month. maybe... september?
Originally posted by WDZ
The user has not logged in after March 2003.
quote:i really don't get that. can you explain it further?
Originally posted by WDZ
The number of total users will go from 28000 to around 20000. I could work around that by making sure the number of deleted users is always added to the total, if you think that's a good idea. I don't really care about showing off how many users we have, but maybe you do.
RE: Pruning users by Wabz on 12-19-2003 at 03:57 PM
Go for it 
Makes no difference to me 
RE: Pruning users by Jeronimo on 12-19-2003 at 04:00 PM
quote:I agree with Choli that maybe it should be a more recent month. A non poster who hasn't logged in for 9 months isn't likely to come back. And if they do, they can just re-register surely?
Originally posted by WDZ
The user has not logged in after March 2003.
Of course, if its feasible, email people, like last time, asking them to log in if they don't want to have their account deleted.
Beyond having the ability to brag about having X thousand number of users, I think its always better to keep the database as clean as possible, and not have thousands of unused usernames etc.
Bottom line - go for it!
RE: Pruning users by WDZ on 12-19-2003 at 04:03 PM
quote:
Originally posted by Choli
None, I agree, but it would be a good idea to send a mail to those users saying about that.
I don't feel like spamming today.
quote:
Originally posted by Choli
why that month? better a more recent month. maybe... september?
We'd lose way too many members if it was september. I chose March because about 25% would be deleted, which seems good to me.quote:Some people might not like the user count decreasing, as more users is better and gives the impression that the forums are more popular.
Originally posted by Choli
i really don't get that. can you explain it further?
RE: Pruning users by Choli on 12-19-2003 at 04:07 PM
quote:I forgot to say: Most users register, ask some question/bug/suggestion and then never come back again. Users with, let's say, 9 or less post should also be deleted. To this users you can use March as month and for 0-posts users use september, eh?
Originally posted by WDZ
The user has never made a post.
Edit: ok to your last reply, wdz
RE: Pruning users by reisyboy on 12-19-2003 at 04:15 PM
Go for it It seems pointless keeping users who havnt loged in for so long and never posted
RE: Pruning users by WDZ on 12-19-2003 at 04:22 PM
quote:With that idea, about 19000 users would be deleted. No thanks.
Originally posted by Choli
I forgot to say: Most users register, ask some question/bug/suggestion and then never come back again. Users with, let's say, 9 or less post should also be deleted. To this users you can use March as month and for 0-posts users use september, eh?
RE: Pruning users by dotNorma on 12-19-2003 at 04:35 PM
Go for it
I always register for stuff than forgot my password and never come back again
RE: Pruning users by BooGhost on 12-19-2003 at 04:49 PM
quote:
Originally posted by WDZ
With that idea, about 19000 users would be deleted. No thanks.
yeah prunning is GOOOOOOOOD
KILL'EM ALL
RE: Pruning users by Omar on 12-19-2003 at 04:51 PM
Yeah...go for it...besides it'll be lots of work to send e-mails to 8000 people...
RE: Pruning users by dotNorma on 12-19-2003 at 04:58 PM
quote:
Originally posted by BooGhost
KILL'EM ALL
We could start from scratch again
RE: Pruning users by Choli on 12-19-2003 at 05:05 PM
quote:who cares
Originally posted by WDZ
With that idea, about 19000 users would be deleted. No thanks.
?quote:
Originally posted by BooGhost
KILL'EM ALL
quote:that is done by a script. it's automaticly done. if a person should do it, wdz wouldn't delete anybody, he's too lazy to send 2 emails
Originally posted by Omaaar
Yeah...go for it...besides it'll be lots of work to send e-mails to 8000 people...
j/k
RE: Pruning users by Omar on 12-19-2003 at 05:12 PM
quote:
Originally posted by Choli
that is done by a script. it's automaticly done. if a person should do it, wdz wouldn't delete anybody, he's too lazy to send 2 emails
What can I say...? I don't know too much about programming...(being a lawyer myself...
) Altough i think WDZ will be up for the challenge of sending 8000 one by one...
RE: Pruning users by Guido on 12-19-2003 at 05:16 PM
I say... about the counter: keep it, it DOES make the forum seem more popular 
/sevillaugh
Also, keep the month as March but maybe instead of 0 posts move it to 3 posts or less... that would be a lot of users who will never come back too... most people who register actually DO post at least once
RE: Pruning users by BooGhost on 12-19-2003 at 05:20 PM
quote:yeah like xxxxxxx ppl has registered will look nice and wont be a lie (just don't say that last time you prunned half of them
Originally posted by Guido
I say... about the counter: keep it, it DOES make the forum seem more popular
)
RE: Pruning users by Guido on 12-19-2003 at 05:22 PM
quote:
Originally posted by BooGhost
yeah like xxxxxxx ppl has registered will look nice and wont be a lie (just don't say that last time you prunned half of them
that's what I mean exactly
RE: Pruning users by Hova on 12-19-2003 at 05:59 PM
quote:I agree
Originally posted by Guido
I say... about the counter: keep it, it DOES make the forum seem more popular
/sevillaugh
Also, keep the month as March but maybe instead of 0 posts move it to 3 posts or less... that would be a lot of users who will never come back too... most people who register actually DO post at least once
RE: Pruning users by dotNorma on 12-19-2003 at 06:51 PM
quote:
Originally posted by Hova
I agree
I agree
x2 [It may be cheating but o well]RE: Pruning users by Wabz on 12-19-2003 at 07:12 PM
I think keeping the counter is a very important fact
BTW DZ how big is the database ?
RE: Pruning users by Chrono on 12-19-2003 at 07:37 PM
March 2003
Keep counter (whatever )
RE: Pruning users by kao on 12-19-2003 at 08:36 PM
bah, delete em, and yes, keep the coubnter, after all, its true, that many peole DID register, just... they got erm... deleted.... 
RE: Pruning users by WDZ on 12-20-2003 at 06:19 AM
OK, the counter will pretend that the deleted users are still there.
* WDZ goes to do some deleting... 
RE: Pruning users by matty on 12-20-2003 at 06:57 AM
quote:
Originally posted by WDZ
I'm about to delete 26% of the registered users on this board. Any objections?
The following conditions must be true in order to be deleted:
1) The user has never made a post.
2) The user has not logged in after March 2003.
Advantages of pruning:
1) Less wasted space in the database and on the member list.
2) More usernames available.
3) Possibly better database performance with less records to keep track of.
Disadvantages:
1) Of course, accounts will be deleted. If one of the deleted members actually remembers these forums, and even remembers their password, they will have trouble logging in.
2) The number of total users will go from 28000 to around 20000. I could work around that by making sure the number of deleted users is always added to the total, if you think that's a good idea. I don't really care about showing off how many users we have, but maybe you do.
just dont make the same mistake as a certain person with a certain account!!
RE: Pruning users by WDZ on 12-20-2003 at 07:01 AM
That would suck if I deleted more than I wanted to...
Fortunately, the pruning is done now and it went smoothly. 
I feel like I accomplished something today, so I'm going to relax now.
RE: Pruning users by matty on 12-20-2003 at 07:16 AM
what are you talking about WDZ, you sit on your ass all day and do nothing ,
so yes as i was saying , do i get something in return for the admin mistake? like elite again , lol
RE: Pruning users by Chrono on 12-20-2003 at 08:26 AM
quote:
Originally posted by ---+[Matty]+---
just dont make the same mistake as a certain person with a certain account!!
shhhhh! 
quote:
Originally posted by ---+[Matty]+---
so yes as i was saying , do i get something in return for the admin mistake? like elite again , lol
no? quote:
Originally posted by ---+[Matty]+---
what are you talking about WDZ, you sit on your ass all day and do nothing ,
wdz here's my toilet. u can slap him with it
RE: Pruning users by Wabz on 12-20-2003 at 10:25 AM
quote:
Originally posted by ---+[Matty]+---
what are you talking about WDZ, you sit on your ass all day and do nothing ,
But he's good at it
quote:
Originally posted by Chrono
wdz here's my toilet. u can slap him with it
* Wabz slaps ---+[Matty]+--- around a bit with a toilet
RE: Pruning users by Kryptonate on 12-20-2003 at 11:03 AM
No wonder so many members never say a thing if there are people like this one
RE: Pruning users by bra1nwash on 12-20-2003 at 12:12 PM
lol 3 almost identical usernames...except for the placing of the _ and the spacings
RE: Pruning users by Choli on 12-20-2003 at 01:33 PM
quote:all them are the same person
Originally posted by bra1nwash
lol 3 almost identical usernames...except for the placing of the _ and the spacings
maybe he wants to register all the variants of his nick
RE: Pruning users by Kryptonate on 12-20-2003 at 01:36 PM
there are also 3 dragons who registered today 
RE: Pruning users by Wabz on 12-20-2003 at 03:56 PM
quote:
Originally posted by Kryptonate
there are also 3 dragons who registered today
Get em Pruned .1 of a milisecond is a lot of time when your on a 56k
RE: Pruning users by matty on 12-20-2003 at 04:21 PM
* matty slaps Wabz with Chrono's toilet