SugarCRM executes a lot of MySQL queries which, with time, may become slow and thus increase the loading speed of your SugarCRM application.
Enabling slow query logging will show you the slow queries executed by your SugarCRM. This, in turn, will help you debug your application and optimize it for better performance.
You can enable slow query logging by logging in to your SugarCRM as admin and going to Admin > System Settings. Once there, check the box next to Log slow queries.
Alternatively, you can enable slow query logging directly from SugarCRM's config.php file by changing this line:
'dump_slow_queries' => false,
to
'dump_slow_queries' => true,
You need help with an application? hostlantern is specialized in hosting and supporting more than 200 scripts. Sign up for our web hosting services and let us help you with your application, 24/7!