SuiteCRM is very slow

👨‍💻 Development Help
1

Hello Experts,

I have recently migrated SugarCRM CE to SuiteCRM. Reason for migration was reports and workflow and also to upgrade CRM to latest version. But after implementing changes in SuiteCRM, I found a terrific performance issues(This is Intermittent, not every-time it is slow). I also not have much database records.
After this I downloaded a fresh new SuiteCRM instance and did a performance testing with demo data and no custom codes, but performance issues still persists. But when I login to http://demo.suiteondemand.com and see I found it works very smoothly.
Can anyone please suggest what all basic environment configurations needed and all environment parameter required to run CRM with 100 concurrent users at a time.

Regards
Madhusudan Singh
SuiteCRM is hosted at Linux environment.

Regards
Madhusudan Singh :frowning:

2

When I see server response time it fluctuates from 4 seconds - 10000 seconds
I already tuned my CRM with all sugarcrm specific parameters which was suggested at http://developer.sugarcrm.com/2010/06/16/quick-pointers-on-sugarcrm-performance/
I haven’t done any environment specific changes, only changed config_override.php files as it was mentioned in the link http://developer.sugarcrm.com/2010/06/16/quick-pointers-on-sugarcrm-performance/
Note: SuiteCRM is hosted at Linux environment.

Regards
Madhusudan Singh

3

Hi Madhusudan,

A server response time of 10000 seconds (over two hours!) is highly atypical. The usual advice I give is to ensure that APC is installed since this will provide PHP Opcode caching. Also ensuring that the database is tuned correctly using something like mysqltuner.pl.

However with that being said it sounds like there are other issues afoot. You can attempt to track this down by enabling log_memory_usage in the config and by enabling the slow query log in MySQL.

Thanks,
Jim

4

This is some parameter which I am setting in config_override.php

$sugar_config[“disable_count_query”] = true;
$sugar_config[“save_query”] = “populate_only”;
$sugar_config[“external_cache_disabled_apc”] = false;
$sugar_config[“external_cache_disabled_memcache”] = false;
$sugar_config[“external_cache_disabled_memcached”] = false;
$sugar_config[“external_cache_disabled_redis”] = true;
$sugar_config[“external_cache_disabled_smash”] = true;
$sugar_config[“external_cache_disabled_wincache”] = true;
$sugar_config[“external_cache_disabled_zend”] = true;

APC is installed in our Our server but still issue persists

Regards
Madhusudan Singh

5

Hi Jim,
Thanks for your reply.

Instead of APC we are using memcache, is that not good ?

Regards
Madhusudan Singh

6

Hi Madhusudan,

Memcache should work fine too (though it wont provide Opcode caching for PHP) but I have less experience with that.

Thanks,
Jim

7

Hi Jim,
Can’t we use both memcache and APC

Regards
Madhusudan Singh

8

You can, SuiteCRM will check for APC/Memcache and use them if available.

However I’m not sure how it decides which to use if both are installed. If it chooses APC then there isn’t much point in having memcache.

Thanks,
Jim

9

Checking the code actually, SuiteCRM will prefer Memcache over APC if it’s installed.

10

Thanks Jim for your quick reply.

I think memcache will also be ok, I also enabled tracker and tried to find slow queries but I didn’t found anything all are normal.
Is there any server parameter need to be changes like number of files to be open or anything like that.

Regrda
Madhusudan Singh

11

Hi Madhusudan,

I’m not sure if there’s anything more I can suggest than what was in my original post. Hopefully someone else on the forum can provide you with some more help/tips.

Thanks,
Jim

12

HI Experts,

Facing Same issue as explained by Madhusudan Singh. Any update??

13

Such slowness, is probably not down to SuiteCRM at all, but something else weird in the environment. Whether it is or not, you need to follow an evidence based problem solving approach - to get to the root cause.

Do you have access to the person who installed the server, and the software on it , and who looks after it? Do they have experience of running many servers of the same operating system /database -or just this one?

Technical questions:

  • do they say the configuration is still what it was when they first set up?
  • what changes have they already made, to make it faster (hardware / database software / PHP etc etc)

Hardware /network:

  • what is the current hardware - CPU spec, RAM size, SSD brand & part number
  • if the hardware is not in the same office as all the users are based - where is it hosted?
    • and how are the users connecting - via 3G? 4G / good broadband?
  •  - if broadband - when one user gets a very slow page (>60 seconds) - do ALL the other users find it slow too? or is it OK for them that minute.
  • is it a dedicated server - ie only used by you and no other companies (ie not a VPS, or cloud instance or ?)

Software:

  • is there any software running on the server apart from that running SuiteCRM and the necessary database etc
  • is it windows / mac or Linux - what version?

Usage patterns:

  • how many users have a login that they could use
  • in a normal week - what is the ‘peak usage’ - ie how many of the users are actually using the system at the same time
  • from the logs - how many pages are served in the hour of ‘peak usage’
  • do you have server monitoring running on the server - what does it show as cPU / RAM / network IO etc during that peak hour
  • is it predictable when it will be slow (eg mostly at 9-10am?. Especially Mondays and Thursdays?)

When a user gets a very slow page (slower than say 60 seconds) - is their next page also slow - or are most of their pages fast - only some pages are slow (is it 1 slow in 10, or 1 in 100 or ?)

How many of the users generate reports in SuiteCRM - how long do these reports take on average (ie, are they always big - eg 60 seconds - but sometimes terrible - eg more than 600)

Users PC’s questions:

  • What browser software are the users using? IE / Chrome /Firefox ?

  • When a user gets a very slow SuiteCRM page, eg > 60 seconds - ask them to test at the exact same time a google search: is that also slow, or is it fast and finished, but the SuiteCRM page is still not finished?

  • What is the hardware spec of the user’s PC’s?