How to improve SugarCRM Performance by up to 20x

Document created by Glenn Richmond on Nov 27, 2016
Version 1Show Document
  • View in full screen mode

Hi SugarCRM Administrators & Developers,


Our team have put together a few tips on optimising the SugarCRM database at scale in our blog. Some of the thoughts are outside of the advertised approaches from SugarCRM, but all using SugarCRM metadata, and all upgrade friendly, but please take with a grain of salt also - SugarCRM can change their structure on any major release


For some of our customers, this helped us reduce the list view query time from almost 20 seconds, to 300ms. You can view the article at:


Improving SugarCRM MySQL Performance at Scale | Database & Query Tuning 

4 people found this helpful