On Fri, Feb 01, 2013 at 03:28:35AM +0400, Ruslan Zakirov wrote: > On Thu, Jan 31, 2013 at 10:24 PM, k...@rice.edu <k...@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, k...@rice.edu <k...@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