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

[Raed El-Hames]

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