Guide: How to speed up your CRM / get a better response time

Hi,

Thought I would create a simple guide of how to make your CRM faster.

PHP Version
It is essential for most websites to be running the latest version of PHP and SuiteCRM is no different, PHP version 7 is support however i couldnt get this to work, so good luck.

File Compression
Why not decrease the file size, which will make load times faster - use the steps below

add this code to the .htaccess file to enable gzip compression

<ifModule mod_gzip.c>
mod_gzip_on Yes
mod_gzip_dechunk Yes
mod_gzip_item_include file .(html?|txt|css|js|php|pl)$
mod_gzip_item_include handler ^cgi-script$
mod_gzip_item_include mime ^text/.*
mod_gzip_item_include mime ^application/x-javascript.*
mod_gzip_item_exclude mime ^image/.*
mod_gzip_item_exclude rspheader ^Content-Encoding:.*gzip.*
</ifModule>

If you get an 500 internal server error, please remove the above code.

Optimize files and images.
You can sit back and relax and let google do this for you - use there page insight tool https://developers.google.com/speed/pagespeed/insights/ and enter the url of your instance if it is not on a local server and then at the bottom of the page click Download optimized image, JavaScript, and CSS resources for this page.
Then keep the page open where you downloaded the optimized files from and then look at tabs e.g minify html and optimize images and then follow that path, then look at the file you downloaded from google and then replace that file.

Make sure the scheduler to prune the database is turned on
Please make sure this scheduler is turned on so it can delete records you have deleted from the CRm, as when you delete records from the CRM it soft deletes them and they still exist in the database.

Quick repair/rebuild wouldnt hurt every so often!

Done this… what else
Finally, you could switch to a VPS (Virtual Private Server) - so you have dedicated resources and are not using shared resources locally or online.

Make sure you keep the CRM upto date so that you can have access to the latest features and new patches to help performance.

ohh and no i dont work for suitecrm, thought i would create a handy guide for you.

5 Likes

thanks for taking the time to do this

For those using IIS I would recommend to install wincache, it help significantly my response time…
https://www.iis.net/downloads/microsoft/wincache-extension

https://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/use-the-windows-cache-extension-for-php

on my test environment I could use the “web platfomr installer” but not on my production machine; I ended up copying the dll “by hand” from test machine to production…

quite an improvement in response time.

2 Likes