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.
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.