If you have a website that sends an email to a client and want to keep a copy of the letter, what is an effective strategy?
If you save it in a table in your database (for example, create a table called Mail), it will be very large very quickly.
Some strategies I've seen are as follows:
- Save it to the file system
- Run the scheduled task to delete old records from the database, but then you will not get a copy;
- Create a separate table for each time frame (every year or every month).
What strategies did you use?
source
share