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

Jesse Vincent jesse at bestpractical.com
Tue Jul 15 01:58:05 EDT 2003


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



More information about the rt-users mailing list