Speeding up Sugar 4.0

[dickb]

A few weeks ago I was asked to test an application in PHP / MySQL. This application was a lot faster than Sugar and I am wondering what I can do to speed up SugarCRM. I am using V4.0 on a Pentium 3 server with 1,5 Gb of memory, 4x500 Xeon and U160 SCSI.

Thanks,
Dick

[longreach]

Sorry Dick - don't follow the Pentium III in the same breath as Xeon? You also do not mention your user load...

Sugar is pretty fast - some security and creeping features seem to be slowing it down a bit as it gets older. No question it would benefit from Sugar taking a bit more time, and doing some optimization.

[dickb]

Sorry Dick - don't follow the Pentium III in the same breath as Xeon? You also do not mention your user load...

You are right, but I have Sugar running on a single P3 machine and a machine with 4x500 Xeon. Both machines don't make a big difference in speed.

All the way Sugar isn't really fast, I get the same repons locally as I get from the demo version at sugarcrm.com. I was wondering if some one has a document with optimazation issues.....

Dick

[longreach]

You are right, but I have Sugar running on a single P3 machine and a machine with 4x500 Xeon. Both machines don't make a big difference in speed.

All the way Sugar isn't really fast, I get the same repons locally as I get from the demo version at sugarcrm.com. I was wondering if some one has a document with optimazation issues.....

Dick

Ahh OK - I understand, thanks.

I have never seen such a document, I'm afraid. Not that many people really seem to understand the whole framework, never mind how to optimize it.

[andrewb]

We have a lot of expirience with SugarCRM. What operating system are you running it on? Sugar may be slow when you have a lot of data, really a lot of data. It can also be slow on windows servers with wrong configuration.

Can you publish these parameters and may be specific modules or places where you notice it is slow. A good idea is also to check the page generation time at the bottom of the pages.

[mpemberton]

I too am experiencing speed issues with Sugar CRM. I've installed it on 2 servers, my local linux box (SUSE 10 AMD 3700+ x64 gig RAM, etc), and on a hosted server running on a windows server (unfortunately I don't have the specs to that). I don't want to fully blame Sugar, because there may be some Apache2/PHP/MySQL tweaks that may increase the speed. However, a few other PHP apps I've installed seem to be more responsive. One install has the demo data installed and the other install is a fresh (no data) install. Obviously the demo data will produce a longer delay, but when it takes approx 30 seconds to display the home page (this is on my local linux box) there is definitely a problem somewhere.

Anyway, I'd like to help if I can because I see value in Sugar CRM. Let me know what I can do to help.

Thanks,
Mark

[Jacob]

There are a ton of things that can be done to improve the speed of sugar. 30 second response time with the out of box data is way longer than I would expect and longer than I have encountered before.

On my laptop the home screen returns in 1 second. (admin user with seed data). The first time to the home screen after an apache restart takes 2 seconds. The follow on trips take 1.

System configuration:
1.7 GHz Pentium M.
Windows XP Pro
Apache 2.0.55
2 GB RAM (similar performance with 1GB)
MySQL 5.0.16-nt in server mode (no other configuration changes)
Zend Core for Oracle on Windows (includes free zend accelerator)

I would be happy to work with you to improve your performance. One of the reasons that I put the server response time on the bottom of every page was to make sure we could easily track and maintain performance.

Jacob

[stevec]

Hi,

We've had some similar issues with accessing a server from the other side of the world and we got it down from 60/30 secs to 1 or 2.

First thing, if you are using IE, go to tools, internet options, then temporary internet files - settings.

On 'check for newer versions of stored pages', make sure you have automatic and not 'every visit to the page'.

Also, consider upping the temporary internet files folder disk space - at least 2 - 3 MB.

That might speed things up.


On Apache, install the deflate module and add this line to the site config:

AddOutputFilterByType DEFLATE text/html text/plain text/xml

(see http://httpd.apache.org/docs/2.0/mod/mod_deflate.html)

You will also be running default caching. I'm currently looking at setting the cache rules more rigorously, so that css, js, and images are cached more heavily - using the rewrite and header modules and MIME types:

http://www.websiteoptimization.com/speed/tweak/cache/

Cheers,
Steve

[AlexXF]

Nothing strange -
+ SQL requests is too 'heavy'
+ Each element in list create a big object in memory
+ HTML page is too big

...

So, what you can do:
Build Front/Back end server. NGINX + Apache is enough.

[Jinson]

Well, SugarCRM is kind of heavy on disk access. Each visit to the homepage takes over 2000 disk operations (monitored with file monitor).

I also encountered really slow load times for my dev machine. I tried installing on my laptop and load times were 4 to 5X better than my dev machine (dev machine was loading up the homepage at ~ 30 seconds). So I reformatted and somehow it seemed to solve my problem. I'm still not very clear where the problem was though....


Here was my situation.

I installed SugarCRM on my development machine.

2.4ghz AMD Barton
1GB DDR400 ram
Maxtor 80 and Samsung 120gb hds

Windows 2000 Professional
MySQL 4.1.15
PHP 5.1.2
Apache 2.2
No accelerator installed


BEFORE Wiping and Reinstalling Windows 2000 (I haven't reinstalled for 4 years)
[SugarCRM HomePage Initial]
Nearly 30 seconds
[Refresh]
25 to 30 seconds

I then turned off all services and applications that were writing to the disk so that the disks were relatively free of any activity.

20-25 seconds.


AFTER Reinstallation of Windows 2000
Note PHP and MySQL configuration are exactly the same as before (they reside on another partition and so were untouched). I also installed back nearly all other services, eg. bots, ircd, etc.

[SugarCRM HomePage Initial]
~ 6 seconds
[Refresh]
~ 2 to 2.7 seconds