Any ideas anyone Roy
Raed El-Hames wrote: > 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: sa...@bestpractical.com > > 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 > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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