putting a pause into ASP?

[Scotter]

Hi -

I have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail
server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?
Thanks!

--
Scotter

[Andrew Urquhart]

*Scotter* wrote:

I have an app that I want to send out an email to each user in our
member list giving them their username & pw, but I don't want to
overwhelm my mail server since there are over 1000 users in my
database.
I don't want to overwhelm my web server, either, having this app hog
all resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript
ASP within the loop that sends out emails to all users?
Thanks!

I'd write a WSH script and implement the pause via
WScript.Sleep(intMilliseconds). The script could be invoked from a shell
object under ASP.
--
Andrew Urquhart
- Contact me: http://andrewu.co.uk/contact/
- 'Staccato signals of constant information
A loose affiliation of millionaires and billionaires' - Paul Simon

[Jeff Cochran]

On Wed, 04 Aug 2004 15:02:53 GMT, "Scotter" <sp**@spam.com> wrote:

I have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail
server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?

Best is none. You could delay the completion until it times out.
Script this on the server and use an ASP page to trigger it if need
be.

No normal mail server will be overwhelmed with 1,000 messages.

Jeff

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2141

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Scotter" <sp**@spam.com> wrote in message
news:xU******************@fe2.texas.rr.com...

Hi -

I have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?
Thanks!

--
Scotter

[Scotter]

wow thanks, guys!
I think what I'll do is go for the middle ground between no pause and a 10
second pause by trying a 1 or 2 second pause.
Will this bit of SQL work with MS Access as the backend database? I suppose
I'm about to find out.
Scott

[Ken Fine]

I faced this exact problem about a year ago, except for me I had more than
30,000 mails to contend with.

Best solution (for us, anyway): Persits makes a product called ASPEmail.
ASPEmail accepts timestamping of when the mail should leave the queue. I
ganged 100 BCC:'s per message, and delayed each message by 1/30000th of a
day. This solves the problem neatly, and the ASPEmail component takes care
of all of the housekeeping. Nary a problem so far.

-KF
"Scotter" <sp**@spam.com> wrote in message
news:xU******************@fe2.texas.rr.com...

Hi -

I have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?
Thanks!

--
Scotter

[Scotter]

ah! I'm using the Soft Artisans product as an email component. I'll check to
see if it supports a command like this. Thanks for the idea!
Scott

[Ken Fine]

Another nice aspect of using someone else's hard work is that you'll
automatically have mechanisms for storing and generating stats,
success/failure... and it's probable if your machine hangs for some reason
mid-send, the component would finish the remaining messages. No way that's
going to happen if you send using a typical "dumb" looping script.

In my case I was advised that a flood of 30,000+ messages could well take
down the entire institutional mailserver, so delaying each message was a
necessity.

-KF

"Scotter" <sp**@spam.com> wrote in message
news:il*******************@fe2.texas.rr.com...

ah! I'm using the Soft Artisans product as an email component. I'll check to see if it supports a command like this. Thanks for the idea!
Scott

[Scotter]

Cool.
Well the mail component I use doesn't support this.
BUT it does report errors and I am checking that within the loop so I'll
know if/when something goes wrong.
And I did set up the delay using the conn.execute like the guys above
suggested.
We'll see how it works.