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

Tue Nov 27 03:42:43 EST 2007

Hi,
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....

Torsten

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com <rt-users-bounces at lists.bestpractical.com>
To: rt-users at lists.bestpractical.com <rt-users at lists.bestpractical.com>
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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

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 bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071127/1bd41f2f/attachment.htm>