<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<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>
<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></BODY></HTML>