[rt-users] SELECT * FROM CachedGroupMembers WHERE GroupId = 'x' AND MemberId = '1', please help

[Raed El-Hames]

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: sales at 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
>