Hi Justin, First of all use Requestor.EmailAddress = '<email address>', so use = instead of LIKE, in the query builder it is "is" operator. Second, add index on CachedGroupMembers(MemberId, GroupId, Disabled) and on Users(EmailAddress) if these are not there already.
On Thu, Apr 29, 2010 at 11:24 AM, Justin Hayes <[email protected]> wrote: > RT3.8.4 > > If I use an unprivileged user (or a privileged user with no rights to see > queues or tickets) to create a very simple search that looks like this: > > Requestor.EmailAddress Like '<email address>' > > then the apache process handling the request maxes out CPU and hangs forever. > If I create the same search with a privileged user that has rights to see > queues etc it's fine and returns instantly. > > This is a big problem as the SelfService interface screens work via requestor > email address, so anyone accessing SelfService severely affects performance > of my RT. > > Anyone got any ideas???? > > Thanks, > > Justin > > ------------------------------------------------- > Justin Hayes > Orbis Support Manager > [email protected] > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
