Last post Sep 20, 2013 09:20 AM by Illeris
Sep 20, 2013 08:17 AM|rajuthri|LINK
I have a requirement for bulk email processing using database html templates.
1. I want to send bulk email from my website. Even it reaches to 1000 mails at a time also .
2. All information about the email have to be stored in Database. Information with status of email sending.
3. I also want the databse design for this requirement.
So i want the best practice for the requirement. Pls Give your inputs.
Sep 20, 2013 09:20 AM|Illeris|LINK
First a small warning : beware of sending bulk mail. Many providers "kill" you for this kind of activities. You'll need to make sure this kind of activity is supported by your provider.
In order to design such system there is a constraint to take care of. Most systems only allow sending a specific amount of messages in a specific timeframe. These are 2 parameters you need to maintain in your system (sent window size and delay between two
The sending of emails can be considered a 2 phase process. First you need to create the messages (if content is variable). This can be done by creating a text body or a html body. You queue these items in database. Afterwards hou have a process that will
sent the items based upon the parameters mentioned before, with tracking information on progress. In my database, I would create a table with at least these fields: