SugarCRM seems slow... but may be normal?

[lanx]

SugarCRM Open Source version 4.5.0d (build 1168)
Running CentOS Release 4.4
Uptime: 3 days and 15 hours

This is a LOCAL machine, at our location, on our local network.

Hardware information:

Pentium 4 2.4
512mb memory
250gb hard drive

Under network usage I have 0 errors or droped packets. Load averages show .04, .13, .06

We do have quite a bit of data, I would say tens of thousands of inputs within the database from leads/opportunities/contacts/phone calls, etc. However, SugarCRM is slow, but I have never been on another SugarCRM platform on someone elses network and server. So I don't know if it is normal or not.

For example, when I click on the leads tab, it took more than 30 seconds for it to load the page (it took that long before the original page even went off and it started to load the leads page). Once the new page comes up (like the leads) it is pretty much instant. It is the time from clicking leads and when the page you are on gets off to load the other page is where it takes so long. I can't believe that 20 to 30 seconds per click is normal. We only have a handful of computers on the network, so I am not sure how to even start diagnosing why it is so slow.

Can I get some diagnostic procedures, such as programs to run to test performance of network, server hardware, etc. I really need to knock this out because we shouldn't have a LOCAL server running our CRM and having it be so slow.

[Angel]

A couple of things...

What is the average number of simultaneous users on the system? Try adjusting your Apache settings to accommodate that load.

Check out this thread: http://www.sugarcrm.com/forums/showthread.php?t=14126 and others in the CTO series...

Use a PHP optimizer. eAccelerator is free and open source: http://eaccelerator.net/

Enable the slow query logging option in system settings and review the log. You might need to create additional indexes and so forth.

[lanx]

A couple of things...

What is the average number of simultaneous users on the system? Try adjusting your Apache settings to accommodate that load.

Check out this thread: http://www.sugarcrm.com/forums/showthread.php?t=14126 and others in the CTO series...

Use a PHP optimizer. eAccelerator is free and open source: http://eaccelerator.net/

Enable the slow query logging option in system settings and review the log. You might need to create additional indexes and so forth.

We only have two (maybe three) people on at any given time.

Will read through that information. In the mean-time, any additional assistance or recommendations? Is 512mb enough memory or would that have anything to do with it? Could this be network problem or the computer hardware not high-end enough for the queries?

[Angel]

2 - 3 users is a very light load, but you haven't stated how much data you are working with.

If you are working with a million rows, I wouldn't expect it to be fast (at least not without some tuning) even if only one user is working on it.

It can certainly be a network issue, but it can be a number of other things as well.

For example, through my own experiences, I've discovered that enabling antivirus script scanning on a client has serious rammifications on performance. I had an old computer that never seemed to perform at the expected level, with page loads taking approximately 10 seconds. Disabling script scanning brought that time down to 2 seconds or less, with the same data.

I also have hands on experience with a system similar to your hadware setup, but for 6 users, with light usage (usually only 2 - 3 at a time). Main hardware difference was that it was a PIII, not P4 and it had an old 80GB drive. It wasn't a hotrod of a machine, but we didn't see any problems like that. Page loads used to take about 3 seconds max.

[kuske]

Each Sugar page has about 1MByte data which must be transferred to the client.
So a normal 1GBit DSL connection loads a page in max. 10 sec.
Response times of 30 sec. I had in an early test installation on a P3 400MHz with 128MB RAM.
512 MB Ram seems to be a little to small, if possible try 1GByte.
In my new system Core2quad 2 GHz, 2GByte RAM, 100 MBit Network pages are loaded within 1-2 sec.

Are you doing some other jobs on the mySQL DB? Perhaps the DB is the throttle because of some table locks?

Good luck
hk

[lanx]

2 - 3 users is a very light load, but you haven't stated how much data you are working with.

If you are working with a million rows, I wouldn't expect it to be fast (at least not without some tuning) even if only one user is working on it.

It can certainly be a network issue, but it can be a number of other things as well.

For example, through my own experiences, I've discovered that enabling antivirus script scanning on a client has serious rammifications on performance. I had an old computer that never seemed to perform at the expected level, with page loads taking approximately 10 seconds. Disabling script scanning brought that time down to 2 seconds or less, with the same data.

I also have hands on experience with a system similar to your hadware setup, but for 6 users, with light usage (usually only 2 - 3 at a time). Main hardware difference was that it was a PIII, not P4 and it had an old 80GB drive. It wasn't a hotrod of a machine, but we didn't see any problems like that. Page loads used to take about 3 seconds max.

I agree, 2 or 3 users is a very light load. We have several thousand leads and each lead probably has on average 10 notes (phone calls/archived email/notes etc). Nothing super intense, and it shouldn't be pulling that data when we click on the LEADS tab and it shows the first 100.

I don't feel as though it is a network issue because we run our phone system (VOIP) through the exact same network (same server as SugarCRM actually). Whether we are all on the phone or in the middle of the night, SugarCRM is still very slow.

I'm not sure what you mean by the antivirus script scanning. Would this be on the server or on the individual PCs? No matter the PC, whether it is an office PC or personal laptop, it is still slow.

I've also tried many of the things put into config.php found in that link above and it didn't speed anything up.

[Angel]

I'm not sure what you mean by the antivirus script scanning. Would this be on the server or on the individual PCs? No matter the PC, whether it is an office PC or personal laptop, it is still slow.

On the individual PCs. Are you running any type of antivirus software on them?

Also, try reducing the ListView to 50 records per page, instead of 100.

[lanx]

Each Sugar page has about 1MByte data which must be transferred to the client.
So a normal 1GBit DSL connection loads a page in max. 10 sec.
Response times of 30 sec. I had in an early test installation on a P3 400MHz with 128MB RAM.
512 MB Ram seems to be a little to small, if possible try 1GByte.
In my new system Core2quad 2 GHz, 2GByte RAM, 100 MBit Network pages are loaded within 1-2 sec.

Are you doing some other jobs on the mySQL DB? Perhaps the DB is the throttle because of some table locks?

Good luck
hk

Is there anyway to monitor, in real-time, the throttle of the mySQL? We do run our phone system through the same server, but like I said, even in the middle of the night, even after a FRESH reboot (clearing system memory), Sugar is still slow.

I am 100% positive that something is not correct because I just installed SugarCRM OpenSource on a Windows server running XAMPP and it was very quick.... maybe 1 - 2 seconds between clicking around, instead of 10+. So Sugar is definitely suppose to be faster, and i'm not really sure what to put the problem on. The server, from what I understand, is more than sufficient.

Any diagnostic tools that I could use to point out the culprit?

[andydreisch]

Hi lanx, be sure to check out Jacob's CTO Series forum. It contains a lot of good stuff re: performance. Also, the Wiki is chock full of tips/tricks.

What you're describing certainly does not seem right.

Andy

[lanx]

Hi lanx, be sure to check out Jacob's CTO Series forum. It contains a lot of good stuff re: performance. Also, the Wiki is chock full of tips/tricks.

What you're describing certainly does not seem right.

Andy

I've done many of the editing of files that that thread makes mention about and no success. Still extremely slow (like ridiculous, 20-40 seconds to load each page).

I am going to get another hard drive and do a fresh linux install with SugarCRM (maybe even the lamp version that is on sugarcrm.com). Will advise on how quickly that is WITH THE SAME HARDWARE and database.