We’re running on 7.8.31 (last version before you were forced to go to SuiteP theme which we hate.) We’ve grown to double the users we had a year ago (10 versus 5). I noticed in the Linux top list the mysql process is taking 97%+ CPU more often than I usually see it. This is also due to a lot of custom external code we’ve added that access the suite DB. However I have periodically been checking the MySQL process list different times of the day and it seems to almost be constantly executing update commands on the email_cache table.
We connect to only one IMAP account inbound email account (hosted on the same server). It is used to store all emails forwarded in that related to various cases. So naturally it has grown, on the SuiteCRM email table side. All emails that come in to Suite from that address are deleted on the email server.
In addition, no one uses the inbox view in the Email module to access the emails associated with the cases. We built a custom Email tab in the Case module to list all the emails for the case. There’s over 1000 email messages in the inbound email account which is all the emails for all the associated cases combined. So the system appears to be basically periodically (probably every time a new email comes in) churning through all the emails in the email table for that inbound account and upated the cache so it’s executing 1000+ update statements.
I would assume if I hacked the code to prevent it from doing that, the list of email in the inbound email account inbox would not be up-to-date which isn’t a big deal as, as I said, we don’t access the emails from tht interface. I’m a little leary about totally disabling it. Maybe ideally, limiting the frequency, such as making it a daily cron even to update the email_cache?
Any suggestions?
On a google search I found a reference that said in the newer versions of suite the email_cache table id deprecated!