Email feeds clean up

Wei Wang asked on May 18, 2023 18:44

Hi,

We have weekly enewsletters sent out to our customers. As a result, the table CMS_Email grows very fast and takes up lots of database spaces. Currently we have a task setup to delete the email entries but it's not very efficient. Is there a better way to manage the CMS_Email table?

We are in Kentico 11 portal engine.

Thank you Wei Wang

Recent Answers


Juraj Ondrus answered on May 19, 2023 10:35

CMS_Email table stores also the sent emails - so, I would maybe set the Archive emails (days) option in Settings -> System -> Emails to a lower number and do not keep the emails for that many days. Then, there is the Clean email queue scheduled task removing the emails which exceeded the archive setting. For the first time I would maybe delete the unwanted records in the DB directly to not to overwhelm the scheduled task.

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.