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

Alek Cesarz acesarz at crowley.pl
Thu Jan 15 12:14:19 EST 2004


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



More information about the Rt-devel mailing list