Hello all,

I'm sending emails for my customers. There is a cost associated to those emails being sent.

I want to keep a trace of everything I sent. The reason for this is for me to be able to tell them how many emails were sent and to who.

So now I am wondering of the way I shold process this. Should I keep that trace in different tables based on the year of the processing.

For example create new tables for each year. So when the year changes create a new table based on that year. Then I add references of what was sent in that table.


Or should I restrict to create two tables. One that will contain a trace of everything and then other one (History) where I will transfer references of what was sent precedent years.

For example this beginning of 2020 I should transfer everything about 2019 in the history table.


Any alternative is welcome. How would you process this and why?