CRM Performance

[chrislynch8]

Hi,

I'm looking for information and tools that I can use to check the performance of my CRM. Beit tools to monitor Mysql, Apache PHP tweaks etc.

Lately users have complained about slow loading, saving times.

Rgds
Chris

[salesagility]

Have you looked at the performance tweaks?

[chrislynch8]

Thanks,

I've had a look at those already. Implemented the ones I hadn't done yet. So hopefully that will help, I've also looked at some of the optimisations for FireFox (network pipelining) and others....

Its has made a difference already. Two days ago to access the detail view of an Account was talking 1.55seconds (from the sugar server response) and the browser was timing 10secs to load....

Today after teh tweaks the server response for the same stuff is .40sec and the browser is timing 2-3secs to load..

Rgds
Chris

[eggsurplus]

We had the same issue where the server generated time was short but the actually response time took forever. We implemented APC for caching and it immediately fixed the problem.

[chrislynch8]

Can you give more detail on this, how you achieved it etc..

Rgds
Chris

[mikesolomon]

This might be of interest http://www.webperformanceinc.com/lib...APC/index.html

[Angel]

You might also want to consider MonYog too:

http://www.webyog.com/en/

Another side note, check your antivirus if you have Windows workstations. The script scanning on those things can severely impact performance.

[eggsurplus]

Here's a note I had in our JIRA instance on this issue:

Guide: http://docs.moodle.org/en/Installing_APC_in_Windows

Following needed for APC:
1. Determine PHP version of server
2. Download PECL by going to http://www.php.net/releases, scroll to the appropriate PHP version, click download for PECL
3. Extract php_apc.dll and drop in php/ext (unless already exists)
4. Open apache/bin/php.ini and add

extension=php_apc.dll
apc.shm_size = 64 <--increase this to the point where it makes a difference
apc.shm_segments =1 <- leave at one
apc.enabled = 1
apc.max_file_size = 10M
5. Make sure Zend is disabled
6. Restart Apache
7. To test if working open include\utils\external_cache.php and set:


define('EXTERNAL_CACHE_DEBUG', true);

[chrislynch8]

Thanks for all the info.

I've tried the MonYog but you have to buy that - I'm trying to keep to the free products

I have found a wealth of information on the APC stuff so I will give that a try.

Rgds
Chris