Hello,
I have recently upgraded my site from 7.5.x to 7.6.4 and have noticed a considerable decrease in performance, after some testing I have found the issue to be ‘Reminders’.
The site is not very large maybe 4500 leads and the reminders table has the same number of records, when there are no reminders the page load times are around 0.5 seconds, when the system includes reminders the load time is around 9 seconds.
I have founds that this isn’t just specifically around the leads module, I find the system load speed slow all over the system.
Can someone please tell me why the reminders are having such an impact on the system and when it is likely to be fixed please?
Steve.
it is very difficult to help when the information provided is so unspecific.
Please provide:
PHP version
Operating system + version
Database + version
That’s a starting point … have you checked your log files? Did you search for any similar issues?
Apologies please find more information below and thank you for your assistance with this issue.
PHP Version: 5.5.35
Apache: 2.4.18
MySQL: 5.6.30
CENTOS
Quad-core Intel® Xeon® CPU E5-2420 v2 @ 2.20GHz Server
16GB RAM
We have also tried loading onto a Windows Server 2012 with same result. Here is an extract from the suitecrm.log. Not sure if it helps
07/05/16 11:46:34 [3676][da41f589-8b38-d94a-8395-56cc28bdad76][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
07/05/16 11:46:34 [3676][da41f589-8b38-d94a-8395-56cc28bdad76][WARN] Image icon_Alerts_32.png not found
07/05/16 11:46:34 [3676][da41f589-8b38-d94a-8395-56cc28bdad76][WARN] Image icon_Alerts_32.png not found
07/05/16 11:46:34 [3676][da41f589-8b38-d94a-8395-56cc28bdad76][WARN] Image CreateAlerts.gif not found
07/05/16 11:46:34 [3676][da41f589-8b38-d94a-8395-56cc28bdad76][WARN] Image Alerts.gif not found
07/05/16 11:47:11 [4300][da41f589-8b38-d94a-8395-56cc28bdad76][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
07/05/16 11:47:11 [4300][da41f589-8b38-d94a-8395-56cc28bdad76][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
07/05/16 11:47:15 [4300][da41f589-8b38-d94a-8395-56cc28bdad76][ERROR] convert: Conversion of 05-07-2016 12:00pm from Y-m-d H:i:s to d-m-Y h:ia failed
Hi Greg. Di dyou manage to look into this issue or is there anything further you need from me to help resolve it? Many thanks