[rt-users] Hitting back in search still causing slow queries...

[James L. Harrison]

Hi Jesse/All,

I am having a problem when a user hits the back button after bringing up a
ticket from the search window...
	1) User performs a search
	2) User clicks on result
	3) user clicks back
	4) Mysqld goes to 100% CPU on a query like the following:
# Time: 030618 14:11:42
# User at Host: rt_user[rt_user] @ localhost []
# Query_time: 66  Lock_time: 0  Rows_sent: 0  Rows_examined: 6524261
use rt3;
SELECT DISTINCT main.* FROM Tickets main, Groups Groups_1, Principals
Principals_2, CachedGroupMembers CachedGroupMembers_3, Principals
Principals_4, Users Users_5, Groups Groups_6, Principals Principals_7,
CachedGroupMembers CachedGroupMembers_8, Principals Principals_9, Users
Users_10    WHERE ((main.EffectiveId = main.id)) AND ((main.Type =
'ticket')) AND ( (  ( (Users_5.EmailAddress LIKE
'%lock%')AND(Groups_1.Domain = 'RT::Ticket-Role')AND(Groups_1.Type =
'Requestor')AND(Principals_2.PrincipalType = 'Group') ) OR (
(Users_10.EmailAddress LIKE '%lock%')AND(Groups_6.Domain =
'RT::Ticket-Role')AND(Groups_6.Type =
'Requestor')AND(Principals_7.PrincipalType = 'Group') )  ) )  AND
Groups_1.Instance = main.id  AND Groups_1.id = Principals_2.ObjectId  AND
Principals_2.id = CachedGroupMembers_3.GroupId  AND
CachedGroupMembers_3.MemberId = Principals_4.id  AND Principals_4.ObjectId =
Users_5.id  AND Groups_6.Instance = main.id  AND Groups_6.id =
Principals_7.ObjectId  AND Principals_7.id = CachedGroupMembers_8.GroupId
AND CachedGroupMembers_8.MemberId = Principals_9.id  AND
Principals_9.ObjectId = Users_10.id  ORDER BY main.id ASC LIMIT 50;

I am using SearchBuilder 0.81_04... Should I upgrade to a newer version?  Is
there a newer version?

Thanks,

Jamie