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...
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...