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 André Lopes over 4 years ago

Hi Mike Pescuma

Definitely queries related to regular users are the most complex ones due to constrains applied by Teams and Roles, but it doesn't explain such a performance degradation.

Where is your instance hosted in? OnSite or OnDemand?

Go to Admin -> System Settings and enable "Log slow queries". Additionally you can update seeting "Slow query time threshold" in order to only display queries slower than a specific time in msec.

Let us know the slower queries so we can help you accordingly.

Kind regards

André Lopes
Lampada Global

Skype: andre.lampada
0 Mike Pescuma over 4 years ago in reply to André Lopes

Thanks for replying! We're hosting it locally. Windows, Apache, MySQL and PHP.

I've just checked off the Log slow Queries option and changed the query threshold to 1000ms.

I'll get someone to test and report back.

Reply

0 Mike Pescuma over 4 years ago in reply to André Lopes

Thanks for replying! We're hosting it locally. Windows, Apache, MySQL and PHP.

I've just checked off the Log slow Queries option and changed the query threshold to 1000ms.

I'll get someone to test and report back.

Children

No Data