Details about this thread
  • State Not Answered
  • Replies 13 replies
  • Subscribers 294 subscribers
  • Views 2910 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?

  • 0 in reply to Jeff Bickart

    We actually only have 1 Team right now.  We're still in the process of setting everything up.  Just got to training people and they reported the slowness... and neither I nor the other admin had experienced it.  We also only have two roles right now the "Admin" role and the "Regular User" role.  Is it worth doing your test?

Reply Children
No Data