[rt-devel] removing "dead" users again...

[Robert Westendorp]

I'm wondering about this too ... any way to do it?
We've got 113095 users listed in the Users table... be nice to preen some
orphaned ones out.

----- Original Message ----- 
From: "Alek Cesarz" <acesarz at crowley.pl>
To: <rt-devel at lists.bestpractical.com>
Sent: Thursday, January 15, 2004 9:14 AM
Subject: [rt-devel] removing "dead" users again...


> greetings,
> i know this topic has been here a few times, but unfortunately i have
> not seen it resolved:
> when using RT for collecting requests from many sources (like when
> catching abuse reports), the users table grows very large and
> performance is becoming very low.
> although there is a way to remove tickets with status "deleted"
> physically from the database, there is no way to remove users who are
> not referenced by any ticket.
> maybe somebody who happens to be perl/db programmer (not a luser like
> me), could write a few lines of code to do this simple task.
> any comments appreciated.
>
> cheers,
> -- 
> Alek Cesarz : NOD manager : ALEK1-RIPE
> +48 22 860 69 60 : Crowley Data Poland
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-devel