<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <DIV><SPAN class="578210423-05042007"><FONT face="Arial" size="2">Strangely, our RT server has suddenly started being really slow loading up the search page and running searches - the same query is logged in the slow-log every time - any ideas:</FONT></SPAN></DIV> <DIV><SPAN class="578210423-05042007"><FONT face="Arial" size="2"></FONT></SPAN> </DIV></BLOCKQUOTE><DIV>Likely you granted some large group of users the right to own tickets.</DIV><BR><BLOCKQUOTE type="cite"> <DIV><SPAN class="578210423-05042007"><FONT face="Arial" size="2"># Time: 070405 16:01:56<BR># <A href="mailto:User@Host">User@Host</A>: rt_user[rt_user] @ localhost []<BR># Query_time: 38 Lock_time: 0 Rows_sent: 288 Rows_examined: 54167891<BR>SELECT DISTINCT main.* FROM Users main , Principals Principals_1, CachedGroupMem<BR>bers CachedGroupMembers_2, Groups Groups_3, ACL ACL_4 WHERE ((ACL_4.PrincipalTy<BR>pe = Groups_3.Type)) AND ((ACL_4.RightName = 'OwnTicket')) AND ((CachedGroupMemb<BR>ers_2.MemberId = Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_2.Grou<BR>pId)) AND ((Principals_1.Disabled = '0')) AND ((Principals_1.PrincipalType = 'Us<BR>er')) AND ((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND ((ACL<BR>_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) AND ((Groups_<BR>3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY<BR> main.RealName ASC;<BR></FONT></SPAN></DIV> <DIV> </DIV> <DIV align="left"><FONT face="Arial" size="2">--</FONT></DIV> <DIV align="left"><FONT face="Arial" size="2">Philip Kime</FONT></DIV> <DIV align="left"><FONT face="Arial" size="2">NOPS Systems Architect</FONT></DIV> <DIV align="left"><FONT face="Arial" size="2">310 401 0407</FONT></DIV> <DIV> </DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Community help: <A href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Commercial support: <A href="mailto:sales@bestpractical.com">sales@bestpractical.com</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Buy a copy at <A href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A></DIV> </BLOCKQUOTE></DIV><BR></BODY></HTML>