Performance problem with history subpanel

[Beegee]

Hi,

I have opportunities with about 100 archived Emails related to this. When I open the opportunity with the subpanel history open, it takes between 5 and 15 seconds to open. The time when you open it with the subpanel closed is between 0.5 and 0.9 sec.
This is only in a test situation where max. 3 persons are working on the system.

I think the reason is the fact that Sugar first performs a lot of queries on notes, meetings, calls and e-mails and then looks for the contacts on each one of these and only afterwards orders the results ascending to only display the first 10 lines.

When you use the VCR buttons to see from 11- 20 of 98 records it is as slow as opening the complete opportunity

Has anybody got the same problem or knows how to solve this.

Config:

Windows XP Server 2003
Sugarcrm 4.5.1h
PHP 5.2.0
Mysql 5.0.27
Apache 2.2.3

Thanx
Beegee

[pmfreire]

I also have performance problems, although I haven't tested the History subpanel.

I notice the performance problems because I want to have a very large Accounts table for a specific user that now has about 40.000 records. For this user to login or for any user accessing the Accounts panel, the operations take HOURS! This is NOT a MySQL problem because I can access the database directly very quickly (for example, using phpmyadmin I can list and query the accounts table in seconds. I suppose this is due to heavy operations undergoing Sugar as Apache really slows down here and keeps slow until I kill the browser with Sugar.

I don't understand why this can happen - in no situation there is the need to retrieve the full table. Even in a list, it should only retrieve the records interval that corresponds to the list page being seen.

I already have posted this problem but the only answer I got was basically to use a smaller number of Accounts ...

I would like to help solving the problem but me and object php don't match ...

[susiewilliams]

Hi there,

Please check out the Performance Tweaks podcast. It contains some tips you can try to boost the perrformance of your app.

You can listen to the podcast here or view a transcript of it.

[Beegee]

hi again,

We have optimized using all the mentioned posibilities and we have won only 1 sec . (We also installed Zend)
JSON had already been installed before.

When I take a look to the log (logging slow queries above 100ms (even 50ms)) and no queries regarding the history were found.

The test server is a Xeon dual core 3Ghz with one Gb ram.

It seems that the heaviest load coms from Apache (so probably PHP)
are there any ways to check where the bottleneck lies?

Regards
Beegee

[Beegee]

I also have performance problems, although I haven't tested the History subpanel.

I notice the performance problems because I want to have a very large Accounts table for a specific user that now has about 40.000 records. For this user to login or for any user accessing the Accounts panel, the operations take HOURS! This is NOT a MySQL problem because I can access the database directly very quickly (for example, using phpmyadmin I can list and query the accounts table in seconds. I suppose this is due to heavy operations undergoing Sugar as Apache really slows down here and keeps slow until I kill the browser with Sugar.

I don't understand why this can happen - in no situation there is the need to retrieve the full table. Even in a list, it should only retrieve the records interval that corresponds to the list page being seen.

I already have posted this problem but the only answer I got was basically to use a smaller number of Accounts ...

I would like to help solving the problem but me and object php don't match ...

hi,

have you tried changing the setting 'save_query' => 'populate_only', and 'disable_count_query' => true, in the config.php?
The system has to perform the query of all records anyway when you open it (+ sort to show the first 20 ones )
Ther are in the wiki section also some cache settings and compression settings available for Apache

regards
beegee

[Beegee]

I just migrated the server to a Dual Xeon Quad-core with 4Gb Ram an a SATA II array of disks (still under Win XP Server 2003 R2)
ans still I get responses over 10 seconds on some occasions.

The server has a charge up to 25%