<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>AW: [rt-users] Really slow Search page startup suddenly</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi philip,<BR>
<BR>
This I found also during the last months. If you open up the search page, he loads every time the whole list of priviledged uisers, in our case a list of 30.000 people.<BR>
<BR>
I'm not sure if this is needed, possibly a change at the querybuilder page can help, change the user drop down to a input field could help, but I didn't tried it till now.<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com <rt-users-bounces@lists.bestpractical.com><BR>
To: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Sent: Fri Apr 06 01:05:30 2007<BR>
Subject: [rt-users] Really slow Search page startup suddenly<BR>
<BR>
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:<BR>
<BR>
# Time: 070405 16:01:56<BR>
# User@Host: 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>
<BR>
<BR>
--<BR>
Philip Kime<BR>
NOPS Systems Architect<BR>
310 401 0407<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>