<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>AW: Re: [rt-users] clean up user table</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi,<BR>
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....<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com <rt-users-bounces@lists.bestpractical.com><BR>
To: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Sent: Mon Nov 26 23:43:26 2007<BR>
Subject: Re: [rt-users] clean up user table<BR>
<BR>
Todd Chapman wrote:<BR>
> Are you having preformance problems related to the users? If not why<BR>
> clean it up? Do you like to play with fire?<BR>
> <BR>
<BR>
Yes, I am. RT3 makes multiple queries per ticket displayed that join<BR>
the very large principals and cachedgroupmembers tables. It causes<BR>
tickets to display somewhat slowly. There's a small but notable delay<BR>
with RT3 3.6.5 and Pg 8.1. The delay was intolerably long with some<BR>
earlier minor revision of 3.6 and MySQL 5.0.<BR>
<BR>
I'm tired of running into these problems when I update some component of<BR>
the system, and would like to prune out the tens of thousands of "user"<BR>
records created by spam through the mail gateway. I'd be grateful for<BR>
any help that the list can offer.<BR>
_______________________________________________<BR>
<A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
<BR>
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:<BR>
<BR>
If you sign up for a new RT support contract before December 31, we'll take<BR>
up to 20 percent off the price. This sale won't last long, so get in touch today.<BR>
Email us at sales@bestpractical.com or call us at +1 617 812 0745.<BR>
<BR>
<BR>
Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
</FONT>
</P>
</BODY>
</HTML>