AW: Re: [rt-users] clean up user table

Ham MI-ID, Torsten Brumm torsten.brumm at
Tue Nov 27 03:42:43 EST 2007

Make sure to delete the users in a safe way with rtx-shredder and not directly from the db. Btw, about how many users we talk? We have NO performance problems with 30.000 active and a half a million inactive users....


-----Original Message-----
From: rt-users-bounces at <rt-users-bounces at>
To: rt-users at <rt-users at>
Sent: Mon Nov 26 23:43:26 2007
Subject: Re: [rt-users] clean up user table

Todd Chapman wrote:
> Are you having preformance problems related to the users? If not why
> clean it up? Do you like to play with fire?

Yes, I am.  RT3 makes multiple queries per ticket displayed that join 
the very large principals and cachedgroupmembers tables.  It causes 
tickets to display somewhat slowly.  There's a small but notable delay 
with RT3 3.6.5 and Pg 8.1.  The delay was intolerably long with some 
earlier minor revision of 3.6 and MySQL 5.0.

I'm tired of running into these problems when I update some component of 
the system, and would like to prune out the tens of thousands of "user" 
records created by spam through the mail gateway.  I'd be grateful for 
any help that the list can offer.


If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
    Email us at sales at or call us at +1 617 812 0745.

Community help:
Commercial support: sales at

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the rt-users mailing list