Hello all --
Here's my problem/question...
I have scripts on my site that hit a database to do several different things. However, if the server is busy, or for whatever other reason (me testing scripts that I forget to put a .movenext operation on a loop, for instance) the user gets tired of waiting and they either close the browser, hit stop, or go back, the script continues to execute until it times out and brings my server to its knees.
Any other scripts executing after that one event simply have to wait until it times out on the server. It's extremely annoying, and I know there has to be a way for me to cash out those transactions when and if any of the above happens so that it doesn't eat up my resources...
If anyone can suggest a good way to do this (using ASP, obviously), then I would greatly appreciate it.
Thanks
Paul Prewett
Here's my problem/question...
I have scripts on my site that hit a database to do several different things. However, if the server is busy, or for whatever other reason (me testing scripts that I forget to put a .movenext operation on a loop, for instance) the user gets tired of waiting and they either close the browser, hit stop, or go back, the script continues to execute until it times out and brings my server to its knees.
Any other scripts executing after that one event simply have to wait until it times out on the server. It's extremely annoying, and I know there has to be a way for me to cash out those transactions when and if any of the above happens so that it doesn't eat up my resources...
If anyone can suggest a good way to do this (using ASP, obviously), then I would greatly appreciate it.
Thanks
Paul Prewett