On Sat, Oct 31, 2009 at 11:21:08AM +0000, Justin Hayes wrote: > I've just upgraded to 3.8.4 and as part of that I've enabled > UseSQLForACLChecks > > RT_SiteConfig.pm:Set($UseSQLForACLChecks, 1); > > However this really slows down load of the homepage. For example with > my default layout load time goes from <1s to 6-7s. The Quick Search > panel alone takes ~3s (for about 20 queues and 40k tickets) for a user > that can see all 20 queues (for myself with SuperUser rights it's much > faster). > > I really would like to keep that setting as it fixes a number of > display bugs with homepage panels and ticket results. > > Anyone have any suggestions? I notice that 3.8.6 is now out. Were > there improvements in that that would help with this setting? > > Cheers, > > Justin > > ------------------------------------------------- > Justin Hayes > Orbis Support Manager > [email protected] > >
Hi Justin, Have you looked at the queries being run to see if there are obvious missing indexes? I know that it is relatively new as a feature so the tuning still has room for improvement. Regards, Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
