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

[Sven Sternberger]

Hello!

I also want to see only real users in my DB, it is not about 
performance, but it would be nice number to show the management.

On Di, 2007-11-27 at 09:42 +0100, Ham MI-ID, Torsten Brumm wrote:
> 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....

But rtx-shredder don't give you a simple way to delete all
users without a ticket, so you have to combine the select
statement from Gordon, and then call rtx-shredder

best regards

sven
> 
> 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
> 
> 
> _______________________________________________
> 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