{"id":40189,"date":"2021-05-28T09:09:33","date_gmt":"2021-05-28T09:09:33","guid":{"rendered":"https:\/\/dev.outrightcrm.in\/dev\/store\/?p=40189"},"modified":"2025-01-30T05:05:53","modified_gmt":"2025-01-30T05:05:53","slug":"tips-that-can-help-in-performance-enhancement-of-suitecrm-sugarcrm","status":"publish","type":"post","link":"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/tips-that-can-help-in-performance-enhancement-of-suitecrm-sugarcrm\/","title":{"rendered":"Ultimate Tips &amp; Tweaks for SuiteCRM\/SugarCRM Performance Tuning &amp; Optimization"},"content":{"rendered":"\n<p>So, your SuiteCRM\/SugarCRM instance is running slow or server response time is too long? It&#8217;s a pain for everyone, it kills employees&#8217; precious time as well as can delay important tasks?<strong> <\/strong>Increasing server RAM and CPU cores can notch up the performance but these can lead to higher monthly operating costs and exceeding budget, so what is the solution?<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-text-align-center is-style-large is-layout-flow wp-block-quote-is-layout-flow\">\n<p> <em>Attention: Before starting to take any steps , please have <a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/product\/suitecrm-database-backup-restore-manager\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"backup of both instance and database (opens in a new tab)\">backup of both instance and database<\/a>.<\/em><br><\/p>\n<\/blockquote>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Initially, let us show you the factors that affect the loading process of the whole page.<\/strong><\/p>\n\n\n\n<p>Let us bring a few tips and tweaks to make the system smoother and do only the required things. PLEASE HAVE AT LEAST 1GB RAM AND CPU with a minimum of 2 cores. CRM runs on schedulers and they need dedicated RAM and CPU cores for this purpose.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">1)CRM Best configurations to speed up page loading<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">2) PHP performance<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">3) MySQL Performance<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">4) Client side performance.<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">5) Third Party Syncing Extensions<\/h5>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>So let us benchmark one by one all of them and see results.<\/p>\n\n\n\n<p>First, go to the home page and note download server performance from the bottom, usually it is in seconds, and then go to your most used module like Accounts, note download time for each.&nbsp;<\/p>\n\n\n\n<p>So let\u2019s say your home page loads in 70 seconds, listview is 50 seconds and the detailed view is 50 seconds, here the target is to reduce the loading time as much as we can. Let\u2019s kick start and see results but before starting, let us confirm our PHP version, MySQL version, and Apache version are compatible with their platform matrix and supported versions.&nbsp;<br><\/p>\n\n\n\n<p>Click on the about link in the CRM and note down your CRM version and Google it with \u201cSugarCRM platform matrix\u201d or \u201cSuiteCRM platform matrix\u201d and check all versions are correctly installed, if not, then the first step will be matching PHP\/MySQL according to platform needs.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1 :CRM Best configurations to speed up page loading.<\/strong><\/h2>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">Please open\/create config_override.php file in the root folder of CRM and put these Lines at the end.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">  $sugar_config['verify_client_ip'] = false;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n  $sugar_config['disable_count_query'] = true;&nbsp;\n  $sugar_config['save_query'] = 'populate_only';\n  $sugar_config['hide_subpanels'] = true;&nbsp;\n  $sugar_config['hide_subpanels_on_login'] = true;\n  $sugar_config['logger']['level'] = fatal;&nbsp;\n  $sugar_config['disable_vcr'] = true;\n  $sugar_config['developerMode'] = false;\n  $sugar_config['list_max_entries_per_page'] = '10'<\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: PHP Best configuration to match SuiteCRM needs<\/strong><\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Using the phpinfo() function, please find the path of the php.ini file. Then edit this file with your favorite editor like nano.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>If possible, have cache installed. It will store the recently used information temporarily, which allows faster data flow and eventually, enhanced performance.<\/strong><\/p><br><p><strong>Linux : APC<\/strong><\/p><br><p><strong>Windows : Wincache.<\/strong><\/p><br><p><strong>Above can be tried, but we recommend doing your own due diligence before implementing this.<\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong> <em>cd \/etc\/php\/7.4\/apache2 <\/em><\/strong> \n\n <strong>nano php.ini\n memory_limit ( 40 - 50 % of Memory),\n max_file_uploads (20 - 50),<\/strong>\n <strong>post_max_size (40 - 50 % of Memory),\n max_execution_time (3600) ,\n&nbsp;upload_max_filesize ( 40 - 50 % of Memory),\n max_input_time = 1000<\/strong><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Increasing above will make sure , SuiteCRM will get CPU attention and memory once required.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: <\/strong>MySQL Performance<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>If your CRM database is not optimized perfectly then you can\u2019t expect to perform it well. In our article of <strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/crm-data-cleaning-effect-of-bad-data-and-how-to-fix-this-issue\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">CRM Data cleaning<\/a><\/strong> we have mentioned how clean databases uplift not only the efficiency but performance as well.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Let\u2019s clean the database first, the first step will be to purge records that are soft deleted. Please Active these 3 cron jobs in admin-&gt;scheduler<\/li>\n<\/ol>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Prune Database on 1st of Month -&gt; Remove deleted records from whole database<\/strong><\/p><br><p><strong>Prune SuiteCRM Feed Tables -&gt;Remove data from feed tables\n<\/strong><\/p> <br><p><strong>Prune Tracker Tables -&gt; Remove data from tracker tables<\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Here in schedulers, it is very important to keep running only jobs which are really required, so all jobs must be inactive until they are not required.<\/p>\n\n\n\n<p>2. Next is MySQL Query Cache. Querying cache results in much faster results for repeating queries.<\/p>\n\n\n\n<p>Find your my.cnf file and put these 2 things<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>&nbsp;query_cache_type : ON<\/strong><\/p><br><p><strong>&nbsp;query_cache_size : 64B<\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong><em>query_cache_size can be changed depends upon needs<\/em><\/strong><\/p>\n\n\n\n<p>Now we must be better as we did most of action , time to reboot server and see result.<\/p>\n\n\n\n<p>Did that make any changes to speed on views?<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Step 4:&nbsp; Client side performance<\/h4>\n\n\n\n<p>By compressing the information that you will be sending to the web browser decreases the load on the browser. It means the browser can operate on a more efficient level and thus results in improved performance.&nbsp;<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>i) compressing all JS \/ CSS files<\/strong><\/p>\n\n\n\n<p><strong>ii) compressing all images.<\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"> Step 5: <\/h4>\n\n\n\n<p>If you running any third party syncing applications , that can be another code level issue.<\/p>\n\n\n\n<p>Try to disable that sync application and then see results.<\/p>\n\n\n\n<p>If that\u2019s the case , contact your developer.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">The Bottom Line<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p>And these are some performance tweaks that you can use to speed up your SuiteCRM\/SugarCRM instance. Keeping the CRM system at an optimal level can be a difficult task, especially if you are not an expert. Therefore, we recommend you hire an experienced SuiteCRM Developer or <a aria-label=\"SugarCRM Developer (opens in a new tab)\" href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/sugarcrm-developers\/\" target=\"_blank\" rel=\"noreferrer noopener\">SugarCRM Developer<\/a> (as per requirement). However, you can deploy the techniques that we mentioned here without any assistance and improve the user experience.<\/p>\n\n\n\n<br\/>\n\n\n\n<p><strong>Related Post:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/suitecrm-create-a-new-scheduled-job-by-code\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>SuiteCRM Create a New Scheduled Job by Code<\/strong><\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/tips-that-can-help-in-performance-enhancement-of-suitecrm-sugarcrm\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Ultimate Tips &amp; Tweaks for SuiteCRM\/SugarCRM Performance Tuning &amp; Optimization<\/strong><\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, your SuiteCRM\/SugarCRM instance is running slow or server response time is too long? It&#8217;s a pain for everyone, it [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":40194,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[54,55],"tags":[],"class_list":["post-40189","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sugarcrm","category-suitecrm"],"acf":[],"_links":{"self":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/40189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/comments?post=40189"}],"version-history":[{"count":3,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/40189\/revisions"}],"predecessor-version":[{"id":60244,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/40189\/revisions\/60244"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media\/40194"}],"wp:attachment":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media?parent=40189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/categories?post=40189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/tags?post=40189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}