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.
#2764 - SecuritySuite performance on large tables
We are in the process of moving from SugarCRM CE 6.5 to SuiteCRM 7.6.
One of the reasons for upgrading is that we need row-level security and SecuritySuite is included in SuiteCRM. But we are concerned about the potential performance impact this might have.
We currently have around 7,000,000 records in the different modules/tables in our database. Every ACL check must now join to a table (securitygroups_records) with 7,000,000 records.
Our security setup is going to be fairly simple. Every record will belong to one security group. And most users will belong to only one group too.
What can we do to get the best performance out of SecuritySuite?
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.