PHP Performance Boost (SugarCRM)

Hi,

I have a very beefy dual xeon server with Win2000 Server and Apache. We have
place a SugarCRM PHP impl on there. The issue is that it is so slow. With
only one user it crawls. It also has a dedicated MySQL server so its not the
db.

Is this normal? Page refresh is around 15-30 seconds. Sometimes the pages
just hang, and several times the server has had to be rebooted...for one
user! Is there anything we can do to speed this up?

Salesforce.com is on JSP and the pages there snap with a refresh of 1-3
seconds. We are considering these two options and would rather use the
SugarCRM due to cost but if the PHP can't be sped up we have no choice but
to dump it.

Thanks,
MC
PS...please do not start a PHP-JSP thing here

Re: PHP Performance Boost (SugarCRM)

On Thu, 06 Sep 2007 20:54:41 +0200, MC <"mica[removethis]"@aisus.com>
wrote:

> Hi,
>
> I have a very beefy dual xeon server with Win2000 Server and Apache. We
> have
> place a SugarCRM PHP impl on there. The issue is that it is so slow. With
> only one user it crawls. It also has a dedicated MySQL server so its not
> the
> db.
>
> Is this normal?

Nope, it isn't for PHP, maybe it is for SugerCRM, ask those people.

> Page refresh is around 15-30 seconds. Sometimes the pages
> just hang, and several times the server has had to be rebooted...for one
> user! Is there anything we can do to speed this up?
>
> Salesforce.com is on JSP and the pages there snap with a refresh of 1-3
> seconds.

My 'normal' pages are usually ready within about 40ms.

> We are considering these two options and would rather use the
> SugarCRM due to cost but if the PHP can't be sped up we have no choice
> but
> to dump it.

I'd say normally the package is the one needing speeding up, not PHP...
Ask their support staff/in their support forums what could be the problem.
That is, assuming normal PHP functionality outside the package is indeed
not hindered. Have you checked other scripts then SugarCRM? Is it the
package or the PHP implementation?
--
Rik Wasmus

Re: PHP Performance Boost (SugarCRM)

MC wrote:
> Hi,
>
> I have a very beefy dual xeon server with Win2000 Server and Apache. We have
> place a SugarCRM PHP impl on there. The issue is that it is so slow. With
> only one user it crawls. It also has a dedicated MySQL server so its not the
> db.
>
> Is this normal? Page refresh is around 15-30 seconds. Sometimes the pages
> just hang, and several times the server has had to be rebooted...for one
> user! Is there anything we can do to speed this up?
>
> Salesforce.com is on JSP and the pages there snap with a refresh of 1-3
> seconds. We are considering these two options and would rather use the
> SugarCRM due to cost but if the PHP can't be sped up we have no choice but
> to dump it.
>
> Thanks,
> MC
> PS...please do not start a PHP-JSP thing here

yeah theres something very wrong there!! dunno what without you
attempting to rule out sugar, but yeah total time from first request
byte to last response byte can be 100ms or less with my php apache
setup which isnt stopped down, and runs on an old P3. admittedly
doesnt do a great deal but thats the typical time. your issue sounds
like a timeout somewhere, or very flaky connection to the dedicated
mysql box.... could it be network settings to that box, ave you used
any timings in your scripts to see where the hang is?

Re: PHP Performance Boost (SugarCRM)

>From what I've heard, Sugar is a bit of a snail.

Have you looked into XRMS[.og]?

It's a true open source, enterprise level CRM application.

Walter
(Yea, I know, I'm on the team, so...)

Re: PHP Performance Boost (SugarCRM)

On 6 Sep, 19:54, "MC" wrote:
> Hi,
>
> I have a very beefy dual xeon server with Win2000 Server and Apache. We have
> place a SugarCRM PHP impl on there. The issue is that it is so slow. With
> only one user it crawls. It also has a dedicated MySQL server so its not the
> db.
>
> Is this normal? Page refresh is around 15-30 seconds. Sometimes the pages
> just hang, and several times the server has had to be rebooted...for one
> user! Is there anything we can do to speed this up?

Yeah - find out what's broken.

Check you've got mysql slow query log configured and see what its
telling you.

Look at the webserver logs and see if they are showing the same times.

Write a wee test script - start with 'hello world' then phpinfo() then
try adding a db connection, then a db query.

C.

Re: PHP Performance Boost (SugarCRM)

On 2007-09-07, C. wrote:
> On 6 Sep, 19:54, "MC" wrote:
>> Hi,
>>
>> I have a very beefy dual xeon server with Win2000 Server and Apache. We have
>> place a SugarCRM PHP impl on there. The issue is that it is so slow. With
>> only one user it crawls. It also has a dedicated MySQL server so its not the
>> db.
>>
>> Is this normal? Page refresh is around 15-30 seconds. Sometimes the pages
>> just hang, and several times the server has had to be rebooted...for one
>> user! Is there anything we can do to speed this up?
>
> Yeah - find out what's broken.
>
> Check you've got mysql slow query log configured and see what its
> telling you.
>
> Look at the webserver logs and see if they are showing the same times.
>
> Write a wee test script - start with 'hello world' then phpinfo() then
> try adding a db connection, then a db query.

Watch the CPU utilization using top, what does it show? If utilization
is well below 100%, you've got something timing out, maybe DNS?