Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 Send 1000000 Email by CDO.Message or CDONTS?

Author  Topic 

haibec
Yak Posting Veteran

54 Posts

Posted - 2007-02-27 : 22:10:50
Imake a page ASP send Email to 1000000 Email .I use CDO.MEssage but process of that pages very low! (To time out. not send full 1000000) . Please help me. I need use CDONTS ? help me

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-28 : 01:25:00
You want us to help you send 1,000,000 spam emails?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-28 : 01:32:50
he just wants to send 1,000,000 emails to his close friends and relatives..




-ec
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-28 : 01:41:27
Poor friends!
Must take a while to remove 1 million emails from his inbox...


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

haibec
Yak Posting Veteran

54 Posts

Posted - 2007-02-28 : 02:15:31
No ! I want send email for customer (about 1000000 diferent)
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-28 : 02:21:16
Does you email server not have sending lists?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-02-28 : 08:51:04
This will give you all sorts of problems - for example, is the POP3 box for your return address equipped to handle all the bounces, Out of Office, and other types of replies?

I strongly recommend that you use a Bulk Mail tool.

If you send them yourself you will have to work out how to get around restrictions imposing trying to bulk mail to multiple Hotmail accounts, and all sorts of other Gotchas.

Kristen
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-02-28 : 09:59:12
An ASP page should not be doing a task that will take a long time! You need to use the correct tool for the job, as others have said. If you want to write the code yourself, it should be executing in a different context rather than on your webpage. i.e., you can trigger the start of a 'sending emails' script or application asynchronously via an ASP page, but you should not be expecting the entire batch of emails to be sent while your web browser is waiting for the page to load!

Do the math ... even if 100 email are sent out every second, how long will it take to send out 1,000,000 emails? (ans: 1,000,000 / 100 = 10,000). How many hours is 10,000 seconds? (ans: 10,000/360 = 27 HOURS!) (ans: 10,000/3600 = 2.7 Hours) (thanks Peso)

Think logically about what you need to do and think logically about the best way to do it.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-28 : 10:06:38
2.7 Hours?
What did I win due to the fact that there is 3,600 seconds per hour?

Or you meant his mailserver is capable of sending 10 mails per second, not 100?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-02-28 : 10:09:51
Ah yes! 3600! That's right, I used 360. Thanks!

Either way -- 2.7 hours is a long time to wait for a web page to load!

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-28 : 10:12:01
A very long time!
I think IIS has a default timeout for 1,500 seconds or something...


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-02-28 : 10:21:08
This reminds me of one of my favorite threads from a few years back, where a guy complained that it took too long to return 10,000,000 rows to put into a report, and he wanted to know how could he optimize his SQL. We tried to explain to him how to filter/summarize, but he insisted that he need 10,000,000 rows of detail for the report. I asked him over and over "do you realize that if you are printing 40 rows of data per page your report is going to be 250,000 pages long? is that really what you want?" but he wouldn't listen. I still wonder how that all turned out.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-28 : 23:11:24
quote:
Originally posted by haibec

No ! I want send email for customer (about 1000000 diferent)



that's a lot of customers. are you Ray Kroc?


www.elsasoft.org
Go to Top of Page
   

- Advertisement -