[rt-users] Performance Issue - RT 3.xx

[Jesse Vincent]

> indices to the CachedGroupMembers table.. The number of linear scanned
> rows scanned has dropped from 167,000 to about 30 for that query I sent
> through before.
> 
> This may slow down the ticket update a little.. If its too bad, then
> drop the indices called group1 and member1 in CachedGroupMembers.


Greg, can you verify that this does in fact improve performance for you?
If so, I'll look at getting the default indices better set up in a
future release.

	-jesse

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.