Sugar Speed Increase Tips?

[jmforums]

Hey Everyone, I finally got Sugar community edition installed with the hopes of getting more organized for my clients and projects that I'm working on. However, it's hard to justify the organizational benefits of Sugar vs the time it seems to take to get the database to load up and input all the information. Are there any tips I can do to speed it up? I have phpmyadmin installed, though I don't know how to use it. So I just wanted to see if anyone could offer some quick tips to speeding up the program. Thanks in advance!

[JVWay]

Well, what are you running it. Pretty hard to suggest anything.

OS, Database, Hardware?

[clint]

My first two recommendations when people ask about making SugarCRM perform better are 1) use one of the installers we provide as they are pre-tuned and/or 2) use a PHP accelerator for session caching such as Zend Platform or APC.

Here is a Sugar Wiki article on performance tweaks worth reading.

Here is a recent blog post on scaling SugarCRM on Sun hardware with guidelines on scaling that they did for the tests. It also points to a great MySQL performance tuning blog post.

And finally we will be providing a webcast on March 19th where one our performance engineer will discuss database tuning for SugarCRM.

[susiewilliams]

In addition to Clint's excellent suggestions, please check out two podcasts we have produced that give some additional tips. One is called Performance Tips and the other is called Performance Tweaks.

The Podcast Page also contains transcripts of each podcast if you'd rather read than hear the information.

[smellygig]

Have been using Sugar for years waiting for performance improvements to really integrate with our business. Have hired some Sugar partners in the past to improve this but still close to unusable. Was going to wait till next stable version of Sugar (5.0d I would hope) but that is not till July now so have to do something in the meantime.

We host this on a dedicated Pentium 4 - 2.4ghz - 2-80GB HD - 1 GB RAM
When 1 user is in Sugar and I am checking top the server is only using ~250mb and average load .2%
Upgrading to 4gb memory even though seems unnecessary

PHP Version 4.4.4
MySQL - 4.1.20
Apache/2.0.52 (Red Hat)
JSON installed
Disabled DetailView VCR Control (4.2.1+)
Sugarlite theme

Locally using Firefox 2 with FasterFox - Turbocharged - 768k SDSL dedicated line
Home page after login ~24 secs
Leads List ~23 secs (~1200 leads)
Leads Detail ~19 secs (only history and activities sub panels expanded - no records in either)

We only use Sugar to manage leads, opportunities and archive emails. It is too slow to use in real time when on phone with customer.

Any ideas on what to try next?

Also forgot to mention the following:
eAccelerator Version 0.9.5
json version 1.2.1


Thanks,
Alex

[eggsurplus]

I'm not sure which version of Sugar you are so not knowing I'd recommend upgrading to the latest PHP and MySQL versions and then most importantly reindex your database. Check out http://dev.mysql.com/doc/userguide/e...g-explain.html for a good start on optimizing your Sugar database indexes. You could see page loads improve to just a couple of seconds with proper indexes in place. We had the same issue and after reindexing and setting up plans to reindex on a nightly basis we saw drastic performance improvements.

[smellygig]

Knew I forgot something

SugarCRM Version 4.5.1e (Build 1049)

Will try the reindex. Any pointers to what tables to focus on?

Thanks,
Alex

[JVWay]

We host this on a dedicated Pentium 4 - 2.4ghz - 2-80GB HD - 1 GB RAM

Locally using Firefox 2 with FasterFox - Turbocharged - 768k SDSL dedicated line
Home page after login ~24 secs
Leads List ~23 secs (~1200 leads)
Leads Detail ~19 secs (only history and activities sub panels expanded - no records in either)

Alex

Are you saying it's taking almost _thirty seconds_ to load a page?

I'm running my Sugar inside a VMware Server virtual machine and never see load times of more than .45 . That's point 45 Not even one second.

If you can get it on a modern Intel XEON or AMD Opteron. Also fast hard drives will make a world of difference. By the size of your drives I'm guessing they're pretty slow. Get at least three SATA 7500 RPM drives. Get them into a RAID 0 + 1 configuration and you'll see tremendous speed increases. Really, unless you have a lot of users 1 - 2 GB ram is more than enough.

Also, make sure your distro is stripped down. We run Ubuntu Linux with no X windows and only what we need to run Sugar.

[smellygig]

If you can get it on a modern Intel XEON or AMD Opteron. Also fast hard drives will make a world of difference. By the size of your drives I'm guessing they're pretty slow. Get at least three SATA 7500 RPM drives. Get them into a RAID 0 + 1 configuration and you'll see tremendous speed increases. Really, unless you have a lot of users 1 - 2 GB ram is more than enough.

It's not a problem with the machine as shown by the top command. Not using any processor (<1% cpu) or more than 25% of physical ram. Hard drives are 7200rpm. These times are also with only 1 user.

This has been an ongoing issue with Sugar and upgrading from previous server to current one as well as upgrading from 4.0 to 4.5.1 did not improve situation. Have gone through most performance tasks suggested and now going to try the DB indexes and or upgrade to MySql 5.0.

Thanks,
Alex

[Angel]

Are the times you posted the server response times or are those calculations for the time it takes to render the page?

Does the home page display faster if you remove the My Leads dashlet? If so, how much faster?

What OS are your clients using? I've seen script scanning on antivirus software cause serious performance degradation.