[rt-users] UseSQLForACLChecks performance problem on RT 3.8

[Ruslan Zakirov]

On Thu, Jan 31, 2013 at 8:45 PM, ktm at rice.edu <ktm at rice.edu> wrote:
> Dear RT community,
>
> While investigating performance issues caused by enabling the
> option UseSQLForACLChecks, a big cause of the slowdown was drawing
> the QuickSeach panel and its resulting DB queries. In RT4 they
> have been consolidated into a single query. I have attached a
> patched version of html/Elements/QueueSummary that does the same
> for RT 3.8.x. The sample that was 15s before is now 2s.

It should be even faster. Don't show inactive statuses if you have
many historical tickets. An index may help. Also, 2 seconds can be
result of hitting Pg problem I mentioned earlier. Explain of the query
will answer this.

> Regards,
> Ken

-- 
Best regards, Ruslan.