Sugar Slowdown

[etabs]

We have been wrestling with a very slow response time since we installed Sugar. The response times that we are getting (reported at the bottom of each page) are between 7 and 15 seconds.

Sugar is installed on a box running Windows 2003 Server (SP1). The hardware is a twin processor 1.8Ghz + 1.8GHz machine with 3GB of RAM. There are very few or no extraneous software processes running on this machine. The only exception is our Server-Side installed Trend Micro anti-virus software that we have configured not to live-scan the SugarCRM
directories. we have rebooted the Sugar server machine several times with no effect.

This is Sugar version Version 4.5.1b (Build 1246) Apache 2.0 and php version 4.4.3

Any ideas as to why we would be seeing these types of slow down?

Thanks in advance,
Aaron

[Angel]

As a test, try disabling Trend Micro all together and see if that helps.

I ran into a situation some time back where McAfee, especially the script scanning engine, was consistently causing this problem. Once disabled, I went from 7 - 10 seconds down to 2 and less. Significantly faster.

[clint]

I suggest checking your Apache and PHP configuration against the recommended configuration in the Sugar Wiki. The settings listed here are intended to provide the best performance on your system.

On a lightly loaded system, you should routinely see sub-second server side performance with the hardware you've listed. It sounds like a potential Apache/MySQL config issue.

Also, a virus scanner could certainly cause the problem you described. Be sure it is configured to NOT scan the MySQL database and Apache log directories as well.

[etabs]

I suggest checking your Apache and PHP configuration against the recommended configuration in the Sugar Wiki. The settings listed here are intended to provide the best performance on your system.

On a lightly loaded system, you should routinely see sub-second server side performance with the hardware you've listed. It sounds like a potential Apache/MySQL config issue.

Also, a virus scanner could certainly cause the problem you described. Be sure it is configured to NOT scan the MySQL database and Apache log directories as well.

Angel and Clint,

Thanks for your thoughts on this issue. We'll look into it and see if we gain any performance boost.

Aaron

[c24]

Hello all,

I'm facing this same issue with my 1.8GHz, 512MB Debian 3.0 machine. Real response times are 4-5 seconds. Strangely though the "Server response time" shown at the bottom of the page is some 1/2 sec, which I guess would be acceptable, only the real speed I see is much slower.

I've got a PHP and a Perl app on this machine and both of them are performing perfectly normally.

Also applied the Apache2 config recommended at http://www.sugarcrm.com/wiki/index.p...Configurations, but see no improvement.

Appreciate any more tips!

Thanks / c24

[clint]

The response time you see on the screen is the server render time. It doesn't account for delivery over the network and then client-side render.

There are a variety of conditions that can affect slow client-side rendering: low bandwidth network connection, high latency between client and server, default FireFox configuration for SSL connections to name the most common.

If you are using FireFox, I suggest reading this Wiki article.

[c24]

Also ran the "Diagnostics" from Admin, and noted that my sugarcrm.log file was missing. Created this w. 777 permissions, but this didn't change the performance as such.

I could email the diagnostics report if someone is interested in taking a look.

TIA / c24

[clint]

So are you running over SSL? Do you see the same performance in both IE and Firefox? How many network hops between your server and client? Have you turned on HTTP compression?

[c24]

We have this setup accessible both over http as well as https. Being company data, the encryption is definitely preferred.

I tested a bit with http, and the performance is a bit better. Pages take ~4-5 secs to load instead of ~7.

Interesting though that IE 6.0 seems to run faster. The difference is noticable compared to FF.

Not sure what to conclude though, because FF is the browser of choice here I'm gonna have a hard time getting users switch to FF just for accessing the CRM.

Thanks
c24

[Deland01]

I'm having major problems with the stability of sugar. User's screens keep freezing constantly, 30 seconds plus responce times & Apache keeps crashing 3 - 4 crashes per day. I only have about 10 people using sugar on a server with the following spec:

Win 2003 Std Edn
3.00mhz Xeon CPU
3.50 GB RAM


Just looking through the Sugar optimisation guide & had a question:


Under Apache Setup I cant find StartServers, MinSpareServers, MaxSpareServers or any other of the variables it advises to increase. I've been looking in the Apache Config file located at C:\Program Files\Apache Group\Apache2\conf

Do I need to add these varables into the httpd.conf file or should they already be in there?