[rt-users] RT 3.6.4 poor query performance

[Richard Ellis]

Hi Jesse,

That's worrying because according to the master list of users I have, 
their should only be 88 users who have permissions to own tickets. Thats 
probably not the cause of the performance issue though, so I'll shelve 
that for now to look at later.

I'll turn slow queries on now and send results tomorrow.

Rik


Jesse Vincent wrote:
> 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?
>
>

-- 
Sun.com <http://www.sun.com> 	* Richard Ellis *
Technical Developer, .Sun eBusiness

*Sun Microsystems, Inc.*
Phone x(70) 24727/+44-1252-424 727
Fax +44 1252 420410
Email richard.ellis at Sun.COM
	sun.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080317/6527b30f/attachment.htm>