Linuc82 Posted August 22, 2021 Share Posted August 22, 2021 I was wondering if anyone else also have issues with a massive tblemails. At this time mine sits at 20.6GB and about 845,000 rows. I honestly wish I could just keep mails for the last 30 days, but that will not work as we sometime have to give clients proof that we sent them a message 7 months ago. If you have a similar issue and have fixed it, please share. 0 Quote Link to comment Share on other sites More sharing options...
string Posted August 22, 2021 Share Posted August 22, 2021 (edited) I suspect that you are either using a custom mail template design with lots of CSS and/or that you are including images in your mails via base64. One way to reduce the table size would be to remove the unnecessary elements from tblemails via a script. DOMDocument is pretty good for this. The downside of this is that when your customers look at the old emails via WHMCS, the mails will not look the same as they did in the original (style missing, pictures missing - depends on what get removed). Therefore, I recommend to do this primarily for old emails and to do it periodically, so that only the emails older than X months are revised. Edited August 22, 2021 by string 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.