October 31, 2007 at 4:44 am
Hi all,
We are planning to create a new application which is used to send email to more that 5million users.My question is that waht will be effect on database when such a large transaction occurs.
Thanks In Advance
October 31, 2007 at 4:49 am
Hi,
Can you provide more information in terms of SQL Server usage for application?
Thanks,
Phillip Cox
October 31, 2007 at 5:07 am
Hi,
We are on the design stage and we are planning to have 7 tables in that database.Approximately 2-3 email per month to 5million clients. Can you tell me the impact on such a huge transaction in transaction log and any comments on the structure of database like RECOVERY MODEL etc.
October 31, 2007 at 5:36 am
Check the link: http://msdn2.microsoft.com/en-us/library/ms187445.aspx (Estimating the size of database). You may get good answer for your application.
🙂
October 31, 2007 at 7:39 am
Are you going to send mails to 5million users simultanreously. if so my first advice check if your mail server ot SMTP server can handle this much load with the respective admin then lets discuss.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
October 31, 2007 at 9:05 am
If you are planning on using SQL Mail, I'm not sure the transaction log comes into effect. The log is used to record changes to data, not mailings, alerts, or other administrative stuff.
SQLMail isn't necessarily built for this. We send 6M mails a month here, but we have an application that reads data from the database, marks it as sending, and then sends it to the user. Not much database impact, lots of disk and SMTP work.
October 31, 2007 at 11:16 am
Yes SMTP only and it have that much capacity.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply