Performance issues for regular users

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 Romney Lai over 3 years ago

Just curious, what version is this? Definitely agree with others that it is most likely related to Teams and Roles.

One thing to note is that the latest on premise version only supports a full Windows stack - Windows, IIS, MSSQL and PHP. See https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_10.0.x_Supported_Platforms/ for more details.

With MySQL, you can also use the EXPLAIN function to see why the query is slow.

Finally, have a read of this great post - https://sugarclub.sugarcrm.com/dev-club/b/dev-blog/posts/performance-improvement-through-teams-denormalisation

Good luck.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Romney Lai over 3 years ago

Just curious, what version is this? Definitely agree with others that it is most likely related to Teams and Roles.

One thing to note is that the latest on premise version only supports a full Windows stack - Windows, IIS, MSSQL and PHP. See https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_10.0.x_Supported_Platforms/ for more details.

With MySQL, you can also use the EXPLAIN function to see why the query is slow.

Finally, have a read of this great post - https://sugarclub.sugarcrm.com/dev-club/b/dev-blog/posts/performance-improvement-through-teams-denormalisation

Good luck.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Mike Pescuma over 3 years ago in reply to Romney Lai

We're on version 10.0. The new version only supports Windows, IIS, MSSQL and PHP? Or also supports. A plug in we are using only allows MySQL, so we had to go with that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel