I have to build a site that will have about a million (they think/hope) users every day. The site will have to email each user with the results from the days competition and their answers so each one will need to be different. The data will come from a SQL Server database.
I can build the site ok but my problem occurs with the emails. Ideally the emails would be sent at night but this would require a) scheduled asp processing which I'm not sure about and b) potentially millions of emails needing to be sent at around the same time.
If anyone has any thoughts/suggestions/help/examples etc I'd be very grateful! Lots of points available to good suggestions. I can increase the points if required.
Please post comments only (not answers), and I'll select your comment as an answer if its useful!