Details about this thread
  • State Not Answered
  • Replies 13 replies
  • Subscribers 294 subscribers
  • Views 2914 views
  • Users 0 members are here
Related content from around SugarClub

Performance issues for regular users

Mike Pescuma

I have a strange situation... and I wasn't sure if this was the right place to put it, but I figured I'd try.

We've come across a strange issue where if a user is set as a regular user, it takes up to a minute for them to access the Accounts page, and roughly similar for Contacts, etc.

If I or the other admin log in, it is up in under 7 seconds.

As an experiment, I upgraded a user from a regular user to a System Admin user and the Accounts page loaded in under 7 seconds.  Put them back as a regular user and it went back to taking almost a minute.

I'm at a loss, unfortunately, since I don't know Sugar very well.  I've more or less ruled out its being a back end database or server hardware issue, since it seems tied to a role.

Any help would be appreciated.

Thanks!

Parents
  • 0

    Do you have lots of Teams? An admin user account does not include checking record level ACL. Regular Users use record level ACL; which includes adding team information into the SQL query.

    As a test, you can create a Role https://<sugarcrm>/#bwc/index.php?module=ACLRoles&action=EditView. In the role, you can call it anything you like. 

    In the Access Type (set it to Admin). This will remove the check for teams for members of the role.

    Save the role

    Add a User to the role.

    Does this improve the performance?

Reply
  • 0

    Do you have lots of Teams? An admin user account does not include checking record level ACL. Regular Users use record level ACL; which includes adding team information into the SQL query.

    As a test, you can create a Role https://<sugarcrm>/#bwc/index.php?module=ACLRoles&action=EditView. In the role, you can call it anything you like. 

    In the Access Type (set it to Admin). This will remove the check for teams for members of the role.

    Save the role

    Add a User to the role.

    Does this improve the performance?

Children