Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#176 - MYSQL Table Query (Speed) question
This is more of a question than a feature request. We are using the Security Groups module on system that has lots of records in the 'securitygroups_records' table, when a Contact / Lead / Target is being deleted it is taking a long time to update the table and is causing it to Lock between updates. We done some tracing on this a we can locate the issue in the M2MRelationship module and the issue relates to the missing module name on a delete which means MYSQL cant use the indexes that are on this table.
This is becoming a particular problem on mass deletes, therefore I was wondering if we should look at adding a new index on this table, one that does not include the module field or if we should try a looking elsewhere? Any help would be greatly appreciated as the module itself is proving very useful.
Other add-ons of interest
Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and e...
QuickCRM Mobile gives you access to Sugar ® or SuiteCRM on your mobile, your tablet (iPhone, iPad, Android) or your laptop with QuickCRM native apps available on App Store, Google Play and Windows Store.