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: [EMAIL PROTECTED] > <[EMAIL PROTECTED]> > To: [email protected] > <[email protected]> > 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. > > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. > > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
