[rt-users] RT 3.6.4 poor query performance

Jesse Vincent jesse at bestpractical.com
Mon Mar 17 12:38:39 EDT 2008


On Mar 17, 2008, at 12:26 PM, Richard Ellis wrote:

> mysql> SELECT * from ACL, CachedGroupMembers, Groups where  
> ACL.RightName = 'OwnTicket' and ACL.PrincipalId = Groups.id and  
> Groups.id = CachedGroupMembers.GroupId;

Ok. Those results tell me there should be 290 names in your  
"SelectOwner" drop down. (That's a lot, but not enough that you should  
see 400s perf ;)

Do you have mysql logging slow queries? If not, can you?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080317/e649c3fc/attachment.sig>


More information about the rt-users mailing list