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.

Free Trial

By clicking you consent to share your profile with the developer

#1687 - Security Suite Performance Issue

Closed General Question created by jobvector GmbH Verified Purchase 9 years ago
Hello, 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: Sales, Marketing, IT, ... 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? Regards System: Suitecrm 7.2.2 (Sugar Version 6.5.20 (Build 1001))
  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    9 years ago

  2. software1 member avatar

    jobvector GmbH Verified Purchase

    9 years ago

  3. software1 member avatar

    jobvector GmbH Verified Purchase

    9 years ago

  4. eggsurplus member avatar

    eggsurplus Provider Affiliate

    8 years ago

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "SecuritySuite was a very good addition to our SugarCRM implementation helping to integrate different functional teams with strictly specified roles."

    Read More Reviews