#1420 - Security group join
We're having some really slow load times in SugarCRM when first logging in and when navigating to the Dashboard. It looks like the dashlets are causing the issue. The following join is being used by some of the dashlets, or EXISTS (SELECT 1 FROM securitygroups secg INNER JOIN securitygroups_users secu ON secg.id = secu.securitygroup_id AND secu.deleted = 0 AND secu.user_id = '58e20515-63c4-d4da-badf-51acfc177b0c' INNER JOIN securitygroups_records secr ON secg.id = secr.securitygroup_id AND secr.deleted = 0 AND secr.module = 'Calls' WHERE secr.record_id = calls.id AND secg.deleted = 0)
I believe this is defined somewhere in the ListView code. Is there any way to keep the dashlets from including this join? This join is an issue because one of our sites has about 29,000 security groups total, and several of their users have 400 or more security groups. That's causing queries to run for 1 to 2 minutes.