Module list view loading takes time

Hello sidhu sidhu,

Follow the necessary steps mentioned into below link.
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Performance_Tuning/Sugar_Performance/

https://developer.sugarcrm.com/2010/06/16/quick-pointers-on-sugarcrm-performance/

SugarCRM Specific

Lastly, a few specific changes just for SugarCRM:

• Add ‘disable_count_query’ => true to config.php. This replaces the “1-5 of 200” with a “1-5 of 6+” and makes a big difference when you have a lot of records. This configuration setting should be a default in a future release of SugarCRM.
• Disable explicit caching in the app by setting ‘external_cache_disabled’ => true in config.php. While SugarCRM can use external caches like APC’s user cache and Memcached for some things, this shouldn’t be enabled unless you have set up the infrastructure to handle these. This configuration setting be a default in a future release of SugarCRM.
• If developer mode is enabled and you are not using it, turn this off! In SugarCRM 6.0, this is under Adminstration -> System Settings -> Advanced. This is off by default, and if it gets turned on and accidentlally left on, it causes severe performance degradation.
• Turn loging down to the minimum that you need. If your SugarCRM installation is on a NFS based document root with multiple servers, this becomes even more important. This is under Administration -> System Settings -> Logger Settings. “Error” or “Fatal” are good options here.
• Turn off tracker features you are not using. This is in Admin -> Tracker. Each enabled piece of functionality causes things to be written to the database, and will slow down page loads. Leave on only what you need for reports that you have written.

If none of this able make your system behaves fast then comment out the logic hooks for the specific module that you are feeling taking much time and then check if that loads fast or not.

Please let me know the update on this.

Thanks

Hello sidhu sidhu,

Follow the necessary steps mentioned into below link.
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Performance_Tuning/Sugar_Performance/

https://developer.sugarcrm.com/2010/06/16/quick-pointers-on-sugarcrm-performance/

SugarCRM Specific

Lastly, a few specific changes just for SugarCRM:

• Add ‘disable_count_query’ => true to config.php. This replaces the “1-5 of 200” with a “1-5 of 6+” and makes a big difference when you have a lot of records. This configuration setting should be a default in a future release of SugarCRM.
• Disable explicit caching in the app by setting ‘external_cache_disabled’ => true in config.php. While SugarCRM can use external caches like APC’s user cache and Memcached for some things, this shouldn’t be enabled unless you have set up the infrastructure to handle these. This configuration setting be a default in a future release of SugarCRM.
• If developer mode is enabled and you are not using it, turn this off! In SugarCRM 6.0, this is under Adminstration -> System Settings -> Advanced. This is off by default, and if it gets turned on and accidentlally left on, it causes severe performance degradation.
• Turn loging down to the minimum that you need. If your SugarCRM installation is on a NFS based document root with multiple servers, this becomes even more important. This is under Administration -> System Settings -> Logger Settings. “Error” or “Fatal” are good options here.
• Turn off tracker features you are not using. This is in Admin -> Tracker. Each enabled piece of functionality causes things to be written to the database, and will slow down page loads. Leave on only what you need for reports that you have written.

If none of this able make your system behaves fast then comment out the logic hooks for the specific module that you are feeling taking much time and then check if that loads fast or not.

Please let me know the update on this.

Thanks

Hi Prashant Patel

      Thank you for your reply.I have gone through the document http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Performance_Tuning/Sugar_Performance/ and updated the list view per pages to 20 and sub panel list to 5 and it fixed my issue.

Regards

Sidhu