On Thu, Jan 31, 2013 at 8:45 PM, [email protected] <[email protected]> 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.
