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

[Ruslan Zakirov]

Hello,

On Thu, Apr 29, 2010 at 8:35 PM, Justin Hayes <justin.hayes at orbisuk.com> wrote:
> Hi Ruslan,
>
> I have both of those indexes already, and in SelfService I have no control over the query being run - it's just trying to show the 'My open tickets' panel.

My open tickets panel uses user's ID as far as I know and it's even
faster. Optimize/Analyze on tables sometimes help convince optimizer,
but anyway read below.

> Also there is no problem with SelfService with a privileged account that has rights to see queues/tickets, so it seems to be something else that's the problem. Something rights related?

Then next step is to look into log of slow queries and figure out what
query is so slow that user waits forever.

> Thanks,
>
> Justin


-- 
Best regards, Ruslan.