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: [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
