[rt-users] RT 3.6.4 poor query performance

[Jesse Vincent]

On Mar 17, 2008, at 11:48 AM, Richard Ellis wrote:

> Hi Jesse,
>

Ok. Next up:

select * from ACL, CachedGroupMembers, Groups where ACL.RightName =  
'OwnTicket' and ACL.PrincipalId = Groups.id and Groups.id =  
CachedGroupMembers.GroupId and (CachedGroupMembers.MemberId = '3' or  
CachedGroupMembers.MemberId = '5');


(The 3 and 5 there should be reasonably stable across RT instances.  
They should correspond to these rows from Groups

|  3 |         | Pseudogroup for internal use     | SystemInternal  |  
Everyone     |        0 |
|  5 |         | Pseudogroup for internal use     | SystemInternal  |  
Unprivileged |        0 |


-------------- 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/9b33cfec/attachment.sig>