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.
#1687 - Security Suite Performance Issue
we have severe Performance Issues with the Security Suite and the following group structure:
We have a Global Group (related to a Global role)
and other Groups (related to another role) like:
Every record (Accounts, Calls, ...) is related to the Global group and every record that is created is also related to the Global Group.
For example if a record should be visible only for Marketing we remove the Global Group and add the Marketing Group to that record.
Our securitygroups_records database table has now approximately 850 000 entries and the load of the server where the database is located is extremely high.
The result is that our system can not be accessed.
My Questions Would be:
1) how can we optimize security suite, so our system would run smoothly?
2) is our current group structure (replicated from Sugarcrm Pro) the cause of this performance issue? how should we change it for a better performance?
(Sugar Version 6.5.20 (Build 1001))
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.