Please, can anyone help me with this issue. My script needs more than 90 sec to execute, but hosting provider (shared hosting) has this time interval as time out. What should I do to give the script more time to execute?

server.scripttimeout = value_in_seconds

though I would be giving serious thought to improving the script performance.

Is this to long of a time for your script to do this? Or is it a good time for you. Maybe you can tell me this and then I will be able to help you out more easily.

"server.scripttimeout = value_in_seconds" - where this line of code should be? My script is sending emails to some users, and it send around 10 emails in 90 sec interval, but I need to send much more emails. It's not spam or something like. These emails are notifications about new content.

If your script is only sending 10 emails in 90 seconds, something is seriously slowing it down.

Are you sending attachments? HTML emails? Both? Whatever it is, that's way too long. That's an email every 9 seconds.

As far as where to put that script timeout, put it just before you start executing any code (usually immediately after Option Explicit is fine.)

Originally Posted by ADAM Web Design

If your script is only sending 10 emails in 90 seconds, something is seriously slowing it down.

Are you sending attachments? HTML emails? Both? Whatever it is, that's way too long. That's an email every 9 seconds.

As far as where to put that script timeout, put it just before you start executing any code (usually immediately after Option Explicit is fine.)

No attachments or HTML, just plain text email. But there is DNSless connection to Access database where all information about receiver is stored. All email bodies are unique, because of name and needed personal code inserted. For sending email "CDO.Message" is used. And, yes, it seems 9 sec. interval for 1 email is too long to be considered as acceptable.

If you think the Access connection could be the issue, break the code apart into two loops. First read all the data from the Access query into arrays, then close the db connection, and loop through the arrays and fire off the emails. That won't solve the problem itself ( unless it's a cursor issue ), but it's a bit more efficient of an approach, and if you add some logging code, you can figure out exactly where the problem is.

90 Seconds is definetly too long. Good luck with the debugging!

The newsletter script I coded for a client can fire off 250 individual email HTML or plain text messages (depending on recipient settings) in under 40 seconds.

As Forrest says it connects to the DB, gets the info once and then constructs and sends the messages.