Posted by Charles Polisher on 09/09/07 16:42

On 2007-09-07, C. <colin.mckinnon@gmail.com> wrote:
> On 6 Sep, 19:54, "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? 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?

[Back to original message]