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

[Kenneth Marshall]

Here is our instance data, not slow at all:

rt36=# select count(*) from CachedGroupMembers;
  count  
---------
 1163547
(1 row)

rt36=# select count(*) from GroupMembers;
 count  
--------
 353086
(1 row)

rt36=# select count(*) from Groups;
 count  
--------
 473803
(1 row)

rt36=# select count(*) from Principals;
 count  
--------
 490777
(1 row)

rt36=# select count(*) from Users;
 count 
-------
 16971
(1 row)

Ken

On Tue, Nov 27, 2007 at 08:21:51AM -0800, Gordon Messmer wrote:
> Ham MI-ID, Torsten Brumm wrote:
>> Hi,
>> Make sure to delete the users in a safe way with rtx-shredder and not 
>> directly from the db.
>
> I'd prefer to, but as I said before, it doesn't work.  The newest version 
> of rtx-shredder has a User plugin that has a no_tickets option, but when I 
> use that, it says that there's nothing to remove.
>
>> Btw, about how many users we talk? We have NO performance problems with 
>> 30.000 active and a half a million inactive users....
>
> From my original message: CachedGroupMembers (254475 rows), GroupMembers 
> (87456 rows), Groups (95138 rows), Principals (110714 rows), and Users 
> (15574 rows) tables.
>
> It doesn't seem like much, but it is mighty slow.  How do your tables 
> compare?
>
> _______________________________________________
> 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
>