Consistent 10-20 second Response Times

[Tim286]

I'm really starting to pull my hair out over SugarCRM's response time. I am consistently getting response times averaging 10-15 seconds, with 20-30 second times not unheard of. At best I may (rarely) see 2-3 seconds, which is still astronomically slow.

My Setup:

• SugarCRM Community Edition 6.1.2
  
  • 1 user
  • demo tables and data
  • 1 custom table (created via module builder) with < 20 fields and < 50 entries
  
  
• This is hosted by a third party on a shared server, which also hosts our website.
  
  • PHP 5.2.13
  • MySQL 5.0.89
    
    • utf8
  • Apache 2.2.14
  • Unix platform. They straight up refused to tell me any further details about the server operating system.

I think it's worth noting that our website is quite speedy and MySQL queries to the tables Sugar uses via either SSH command line or PHPMyAdmin are also very quick (thousandths to ten-thousandths of a second.)

I've tweaked, Googled, Binged, and forum searched for solutions for over two weeks now. I've scoured the guide for optimizing SugarCRM for large systems as well as the one for smaller systems. I've gone through all relevant sections of the developer's guide and knowledge base. I've contacted our hosting support. So far nothing has helped, and I am plum out of ideas.

Any suggestions?

[Angel]

Have you tried enabling the logging of slow queries and memory consumption so you can review it within the sugar log file?

[Tim286]

I have enabled slow query logging (100msec) and gotten nothing in the logs from that. I have not tried memory consumption; I'll do that now.

Thanks.

[item]

Hello,
Config see my signature.
These computer is too a home directory/Calendar/... for 100 users and VPN too.
A MacPro Intel 2009 with 12GB ram
I have put PHP setting to use 512MB

< 1sec for a list of 50 records (Contacts-Customer)
Same with a custom module with many relation to (Contacts-Customer-....)
With only developper mode disable.

I have a MacPro G5 with 2GB ram, only for my developement environement and the response is bad.. with same setting than the Intel, i have same data ... > 3 sec

Only, we do not use "email" on sugar, jiust for send invitee and notification.

Regards

[Tim286]

I used SugarCRM throughout the rest of the day with slow query (>100msec) logging and memory usage logging and the log is completely empty - there is not a single new entry.

I appreciate the suggestions so far - any other ideas? Thanks.

[Angel]

Given that's the case, it would seem the culprit is most likely the web server/PHP.

Do you have any sort of optimizer/accelerator installed (APC, eaccelerator) ? If not, you should consider installing one.

Although, I should add that even without one, the response times that you are seeing seem excessive to me.

Is this a shared server?

[Tim286]

Yes, it is a shared server. I can try to find out about an accelerator. My interactions with the hosting provider so far have been... difficult.