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...
SugaryCB : Joomla! & SugarCRM Integration
The only Joomla and SugarCRM integration you need. Sync your Joomla users to Leads and Contacts/Accounts in SugarCRM. Define custom operations based on specific events or scenarios such as creating, converting, or updating leads.
Process Manager 4.5
Your Sugar Workflow Solution! Powerful Process Automation software for all editions of SugarCRM and SuiteCRM (Visit https://store.suitecrm.com/) that will allow you and your employees to spend more time doing what they do best: 'Selling To and Servicing Your Customers' and less time trying to manag...