Local Sugar install is slooow

[sunside]

Hi,

for about a month, my local test installation of Sugar reacts really sluggish, to the point that it is unusable. E.g., the response time for clicking the "Contacts" tab is 23 seconds. This has occurred about 1-2 months ago.

Now I tried a fresh re-install from scratch of the latest Sugar version with no data in it, but the problem still persists. This kind of keeps me from working on improving our Sugar instalaltion if I don't have a test system.

My config:
Sugar Open Source v. 4.2.1
OS: Windows XP Professional
PHP Version 4.4.2-pl1
MySQL - 5.0.20-nt
Server: Apache/2.2.0 (Win32)

[stevec]

What are the response times at the bottom of each screen? If that matches the time it takes to display - it looks like it's probably database-based. If the displayted time is OK but it's still taking a long time to render - then it's probably the webserver, the network or the browser.

There are a number of 'performance' threads that are very detailed but it'll be good to identify the area of fault to start with.

[sunside]

I have not compared the response time displayed vs. the real time until the page is displayed, but the indicated 23 seconds seem a good estimate for the total time.

I am quite certain that it is not the database. I have enabled the "log slow queries" switch (with the standard setting of 100 msec) and tested the one query which was in the logs directly with phpmyadmin. It did behave normally on issuing this query directly; in fact the database runs smoothly and just fine for other projects. And it was a query with 0 records and a LEFT JOIN on the PRIMARY keys, so that cannot be the problem.

I have read through all the threads concerning slow performance, but did not find an applicable solution to my problem. There were some posts indicating that I'm not the only one with this problem on a localhost with Windows and Apache 2 config.

It can't be the network since both the MySQL Server and Apache are installed on my local Notebook, no network (and AFAIK not even the TCP/IP stack) involved. It can't be the borwser since the Sugar installation which is hosted on a (Linux) server runs much faster with the same browser (Firefox 1.5.0.4).

This would leave the webserver. Enabling any buffering or page compression would actually slow down things since there is no network in between. If you can think of other switches in the httpd.conf or modules that are known to conflict with Sugar, please point me to this information. Note that the problem only appeared about 1-2 months ago after some Sugar patch. Since then, I have completely rebuilt my entire Windows and Apache/MySQL installation from scratch, but this did not solve the problem.

The installation is an out-of-the-box XAMPP package which is a pre-configured Apache, MySQL and PHP package with some goodies like phpmyadmin and an installer binary. I never had any performance issues using other PHP software, or my own applications. I think it would be not so hard to reproduce this, maybe I can try this on another machine, downloading XAMPP & Sugar from scratch and not changing any configurations.

Cheers
Sunside

[stevec]

Well, we use linux and apache2 but I've also got it running on apache2 on my desktop and though slower than the main server, it's OK. What sort of server response times are you getting at the bottom of each page?

[sunside]

As I wrote: 23 sec
The time until the page is displayed is around 30 sec
Apache takes almost 100 % of the CPU cycles after requesting a page

[stevec]

With that server response time of 23secs, I would put the issue with the MySQL or PHP configurations.

I had a speed issue on a local machine after a migration - that was fixed by running the various mysql optimise and repair funtions on some of the tables. But that tended to be specific on large tables like emails. If you've reinstalled a blank db, I can't imagin its that.

It's a bit of work, but have you tried installing Apache2, PHP and MySQL individually rather than the packaged stack?