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?
-
"Incredibly useful. It's one of the first features you need. This needs to be part of the core product." - MTP
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
8 years ago
It sounds like you are using groups for specific user teams. Is the goal of doing that to extend the Assigned User/Ownership of a record so that certain users can have another user "ride along" to have access to their records?
Whatever the answer is, it sounds like you can't avoid the volume due to how many records there are. I suggest looking through the recommendations on this case for optimizing your instance: https://www.sugaroutfitters.com/support/securitysuite/1420
8 years ago
We'll be using groups for multi-tenancy; starting out with only two tenants. Most logged in users will only see items in their own "domain". There will be a small number of users who'll be able to see both domains.
Thanks for the pointer to the optimization suggestions on case 1420.
8 years ago
Happy to help. I just converted those tips into a new doc: https://www.sugaroutfitters.com/docs/securitysuite/optimizing-securitysuite
Closing this case out for now, but feel free to follow up here as needed.