On 05/30/2013 12:55 AM, Danie Brink wrote: > Is it possible for us to change the SQL query that is run for the "RT at > a glance" front page that shows the last 10 unowned new tickets? With > our RT Ticket count hovering around 4million the current query performs > a complete table scan to sort the show the last 10 (filtered) so we > would like to customize it more for our needs. > > Any pointers where to look for and modify this query? (We're on RT3.8.7).
I suspect you want the $UseSQLForACLChecks option: http://bestpractical.com/rt/docs/latest/RT_Config#UseSQLForACLChecks -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
