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