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