Performance of sugarcrm

[Rajesh Patel]

Thanks for the wonderful product...
But there are some issues related to performance of sugarcrm I have xampp on my Linux server with 8 GB RAM on server

Mysql configuration
-----------------------------------------------
# The MySQL server
[mysqld]
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512M
net_buffer_length = 16M
read_buffer_size = 256M
read_rnd_buffer_size = 512M
myisam_sort_buffer_size = 8M
query_cache_type = 1
query_cache_limit = 16M
query_cache_size = 64M

in php.ini file memory_limit is set to 1024M

In my sugarcrm instance their are only 5000 leads then also system is slow....
It is taking time to open the home page, Dashbord, Emails etc

How can i improve the performance of sugarcrm please suggest on the same...
Thanks in advance....

[salesagility]

The wiki has some good suggestions

http://www.sugarcrm.com/wiki/index.p...ormance_Tuning

[Rajesh Patel]

I have gone through all the forums and user guide on sugarcrm but has not help me to improve the performance...

Any suggestion..mysql and php configuration is already posted by me...

Please help...

[salesagility]

What sort of response are you getting for:

Home Page
Accounts
Contacts
Emails

If you have the log server response times set to on this will appear at the bottom of the each page

[Rajesh Patel]

Server response time is 4.65 second when fetching the 2000 Leads same is the case with other Modules.

[ruchida]

This is weird. You have plenty of resources and a small amount of data. You should have much better performance.

There may be an issue in your network.

Please turn on debugging by looking at this document, and just log in the system.

Then look into the log file and see what operation is causing the slow performance.

[Rajesh Patel]

I have changed the log level to debug and generated details in log file, but i am not able to understand what should i look into , any specific detial..

I have attached my log file, please suggest some way to improve the performance...

[ruchida]

Hi

Your system looks very healthy.

I think you performed the Leads listview. Was this operation slow?

What about the log in action. Do you think it was slow?

[Rajesh Patel]

Yes i have perform the serch on leads.
firstly i have changed the system setting to display 2000 records and then goto leads and click on search here it takes times to display 2000 Leads and also to display dashboard. My concurrent user might not exceed 7 t if they all login at the same time then system goes slow...

[ruchida]

Do you like to display 2,000 records per page in Leads?

My thought is that your server is performing its best currently. To improve the performance, some database scheme and SQL statements in SugarCRM need to be modified.