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
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.
SugarCRM Survey Rocket
SugarCRM Survey Plugin
With Surey Rocket, a SugarCRM survey plugin, you can build surveys that trigger automatically to get real-time feedback from customers. It gives custom survey templates, online polls & more. Moreover, you can use the CRM data using inward and outward piping mechanism.