Hi; RT-3.8.7 apach2, mysql5,mod_perl2,DBIx::SearchBuilder v1.56; -- I have Set($StatementLog,'debug') so I can see sql statements -- And I have Set($UseSQLForACLChecks,'1');
I am seeing lots of SELECT * FROM CachedGroupMembers WHERE GroupId = '2034' AND MemberId = '1', in my logs 2034 is a user defined group, with lots of members (staff users). These queries are showing up every time there is a ticket listing (ie home page my tickets ), or search list. As a result the page display is taking around 10 seconds longer I noticed these only happen if $UseSQLForACLChecks is set. I tracked it down to somewhere in Elements/CollectionList , but I cannot find the reason for it. Anyone else seen this and have a fix?? Regards; Roy _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
