469,349 Members | 1,596 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,349 developers. It's quick & easy.

putting a pause into ASP?

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
Jul 19 '05 #1
8 6664
*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
Jul 19 '05 #2
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
Jul 19 '05 #3
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

Jul 19 '05 #4
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
Jul 19 '05 #5
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

Jul 19 '05 #6
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
Jul 19 '05 #7
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

Jul 19 '05 #8
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.
Jul 19 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andrew | last post: by
11 posts views Thread by Paminu | last post: by
2 posts views Thread by eSolTec, Inc. 501(c)(3) | last post: by
8 posts views Thread by Lloydm | last post: by
3 posts views Thread by garfunkel214 | last post: by
2 posts views Thread by bmerlover | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.