[rt-users] Requestor email address search hangs apache process

[Kenneth Marshall]

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.hayes at 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