Slow performance caused by reminders table

Hi. I have a performance issue that makes the response of any module take too long for about 10 seconds. After a lot of checking of my database, I found out that the problem was caused by the table reminders and I have discover that because if I truncate that table, the performance return to 0.3 seconds.

Obviously, truncate the table is not a valid solution, so I have follow the instructions in this post: https://suitecrm.com/forum/feedback/8320-performance-issues-regarding-suitecrm-reminders-alerts-logic#35601

But It doesn’t worked maybe due to my version, I really don’t know.

Please, if anyone know other solution, It will be very appreciated.

I’m using the Versión 7.6.4 in Ubuntu 14 x64.

Thanks.

Hhmm, I remember a similar bug a while back… have you seen this?

https://github.com/salesagility/SuiteCRM/issues/1861

Hi. I did but if the solution is upgrading, I done that before and it didn’t solve the problem, even to the latest version. Any suggestions?

Maybe your Reminders table actually got too large, for some reason.

Do you have any problems with deleting the data from that table, or at least most of the data? For example, everything before March 2017.

Of course, make a backup of the data first, in case you regret it.

Thanks… but I’m looking for a more permanent solution, there must be a way to fix this and safe for upgrades.

I’m not sure if this couldn’t permanently solve your problem. It depends on how exactly your problem was formed, which we don’t really know yet.

But once that table got filled up and SuiteCRM was going crazy trying to process it all, every single time a user loaded any screen at all, all kinds of things might have gone wrong in your install.

Other queries might have started giving timeouts, the Prune jobs might have stopped clearing the database, etc.

My point is: unless you can really debug your problem and get a full grasp of happened (or what is happening), it just might be a good strategy to simply get things efficient again (clear reminders table, check if prune job is running without errors) and then keep an eye on that table to see if it fills up again. Maybe with the new version of SuiteCRM you have now, it will stay efficient.

Good advice. Thanks