On Thu, Feb 05, 2009 at 10:59:13AM -0500, Rob Munsch wrote: > On Thu, Feb 5, 2009 at 8:15 AM, Emmanuel Lacour <[email protected]> > wrote: > > > Depending on your RT version, you can try the following option: > > > > Set($UseSQLForACLChecks, 1); > > > > but read comment on it in RT_Config.pm before enabling it. > > Go not to the docs for counsel, for they will say both no and yes. > "In some cases it result in performance improvements, but some setups > can not handle it." > Is this hardware- or memory-dependent? What are the variables in > whether it improves or degrades...? > > At any rate, trying it now, as this sys isn't in production yet. > Thanks for the pointer, i saw that option but i didn't understand what > it meant at the time. >
I suspect that with certain backends or SearchBuilder versions, the DB plans could be umm... non-optimal for this feature. :) I am trying it here as well. Cheers, 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
