On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes 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 > justin.ha...@orbisuk.com > Hi Justin,
Perhaps you are missing an index. What query is hitting the database for the slow search? What DB backend are you using? Cheers, Ken Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com