[rt-users] UseSQLForACLChecks performance problem on RT 3.8

[ktm at rice.edu]

On Fri, Feb 01, 2013 at 03:28:35AM +0400, Ruslan Zakirov wrote:
> On Thu, Jan 31, 2013 at 10:24 PM, ktm at rice.edu <ktm at rice.edu> wrote:
> > On Thu, Jan 31, 2013 at 09:02:59PM +0400, Ruslan Zakirov wrote:
> >> 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.
> 
> Explain quoted below looks good. Have you meant 2 seconds for the page
> or quick search box only? I think whole page and it sounds not bad.
> 

Yes, it is for the whole page load. I am glad that I was not missing
some low-hanging fruit. Thank you for the help.

Regards,
Ken