<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jesse,<br>
<br>
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.<br>
<br>
I'll turn slow queries on now and send results tomorrow.<br>
<br>
Rik<br>
<br>
<br>
Jesse Vincent wrote:
<blockquote
cite="mid:029CEEAC-1C90-4708-B39E-8DA08F59CF78@bestpractical.com"
type="cite">On Mar 17, 2008, at 12:26 PM, Richard Ellis wrote:
<br>
<br>
<blockquote type="cite">mysql> SELECT * from ACL,
CachedGroupMembers, Groups where ACL.RightName = 'OwnTicket' and
ACL.PrincipalId = Groups.id and Groups.id = CachedGroupMembers.GroupId;
<br>
</blockquote>
<br>
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 ;)
<br>
<br>
Do you have mysql logging slow queries? If not, can you?
<br>
<br>
<br>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table border="0" cellpadding="0" cellspacing="0" width="519">
<tbody>
<tr valign="top">
<td height="121" width="98"><a href="http://www.sun.com"><img
moz-do-not-send="true" src="file://///home/re100941/6h_top.gif"
alt="Sun.com" border="0" height="92" width="98"></a></td>
<td style="font-family: Helvetica; font-size: 12px;" height="121"
width="249"><b> Richard Ellis </b><br>
Technical Developer, .Sun eBusiness <br>
<br>
<b>Sun Microsystems, Inc.</b><br>
Phone x(70) 24727/+44-1252-424 727<br>
Fax +44 1252 420410<br>
Email <a class="moz-txt-link-abbreviated"
href="mailto:richard.ellis@Sun.COM">richard.ellis@Sun.COM</a><br>
</td>
<td style="font-family: Helvetica; font-size: 12px;" width="172"><img
moz-do-not-send="true" src="file://///home/re100941/q01.gif"
alt="sun.com" height="118" width="172"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>