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!

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
0 Romney Lai over 3 years ago in reply to Mike Pescuma

Good question. We don't use WIndows so you should ask Sugar Support for a clarification.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Enrico Simonetti over 3 years ago in reply to Mike Pescuma
We only support the full Microsoft stack, not a combination of technologies (in your case MySQL is not a supported option on Windows).

Extract from here: https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_10.0.x_Supported_Platforms/

"Sugar only supports the use of Microsoft SQL Server in conjunction with the following:

Windows Server Environment

IIS Web Server

Microsoft SQL Server Driver for PHP

Please use the driver version that corresponds with your version of PHP. For more information, please refer to Microsoft's System Requirements for the PHP SQL Driver documentation."

Perhaps the documentation could be clearer in stating that MSSQL is the only supported database technology on Windows Server. I will let our documentation team know

Thanks!
--

Enrico Simonetti

Sugar veteran (from 2007)

www.naonis.tech

Feel free to reach out for consulting regarding:

API Integration and Automation Services

Sugar Architecture

Sugar Performance Optimisation

Sugar Consulting, Best Practices and Technical Training

AWS and Sugar Technical Help

CTO-as-a-service

Solutions-as-a-service

and more!

All active SugarCRM certifications

Actively working remotely with customers based in APAC and in the United States
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel