by eggsurplus

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.

Cancel at any time!
Free Trial

#2764 - SecuritySuite performance on large tables

Closed General Question created by dfstrauss 3 years ago

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?

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    3 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:

  2. dfstrauss member avatar


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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "This impressive add on is easy to use, extremely flexible, and huge time saver. This add on exceeded our expectations and is worth every penny!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.