Script taking longer than expected to complete: Consequences?

[Colin Steadman]

I've setup a very simple page which allows a group of users to start a
procedure in Oracle from an ASP page (relevant code copied below). I
was led to believe that the processing job was fairly quick and would
only take a minute to complete.

However to my disappointment, having only built and deployed the page
a few days ago, I've already had a call from one of the users who
tells me that its just timed out on them (timeout currently occurs
after 90 seconds). I've made a quick mod to the page and used
Server.ScriptTi meout 600 to give the script plenty of time to
complete.

However I'm now concerned about what would happen if the user
interrupted processing mid-way through by accidently closing the
browser window or something. What would happen on the database in
this situation?

To get around the problem I'm thinking about putting a transaction
around the execution part of the code. But would this work if the all
the SQL is doing is starting an Oracle procedure? I've only ever used
it with straight updates before!

TIA,

Colin


On Error Resume Next

Dim cn
Dim sql
Dim arSQL()

Redim arSQL(3)

arSQL(0) = "begin"
arSQL(1) = " db2acs_inbound_ api.LOAD_MANUAL _INVOICES;"
arSQL(2) = " commit;"
arSQL(3) = "end;"

Server.ScriptTi meout 600

Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.execute Join(arSQL,"")

[Ray Costanzo [MVP]]

Re: Script taking longer than expected to complete: Consequences?

If the user closes the browser window, the script will continue to run on
the server. Once the request is made to the server, it starts doing what it
has to do and runs until it's finished (or errors out, times out, whatever).
Asuming that you cannot do anything about the duration of the database
operations, perhaps you'll be interested in some of the ideas here.

http://www.aspfaq.com/show.asp?id=2194

Ray at work

"Colin Steadman" <google@colinst eadman.com> wrote in message
news:4062dca4.0 410130753.4a1a4 50f@posting.goo gle.com...[color=blue]
> I've setup a very simple page which allows a group of users to start a
> procedure in Oracle from an ASP page (relevant code copied below). I
> was led to believe that the processing job was fairly quick and would
> only take a minute to complete.
>
> However to my disappointment, having only built and deployed the page
> a few days ago, I've already had a call from one of the users who
> tells me that its just timed out on them (timeout currently occurs
> after 90 seconds). I've made a quick mod to the page and used
> Server.ScriptTi meout 600 to give the script plenty of time to
> complete.
>
> However I'm now concerned about what would happen if the user
> interrupted processing mid-way through by accidently closing the
> browser window or something. What would happen on the database in
> this situation?
>
> To get around the problem I'm thinking about putting a transaction
> around the execution part of the code. But would this work if the all
> the SQL is doing is starting an Oracle procedure? I've only ever used
> it with straight updates before!
>
> TIA,
>
> Colin
>
>
> On Error Resume Next
>
> Dim cn
> Dim sql
> Dim arSQL()
>
> Redim arSQL(3)
>
> arSQL(0) = "begin"
> arSQL(1) = " db2acs_inbound_ api.LOAD_MANUAL _INVOICES;"
> arSQL(2) = " commit;"
> arSQL(3) = "end;"
>
> Server.ScriptTi meout 600
>
> Set cn = Server.CreateOb ject("ADODB.Con nection")
> cn.open Session("PROVID ER")
> cn.execute Join(arSQL,"")[/color]

[Colin Steadman]

Re: Script taking longer than expected to complete: Consequences?

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:<#lTTe1TsE HA.1336@tk2msft ngp13.phx.gbl>. ..[color=blue]
> If the user closes the browser window, the script will continue to run on
> the server. Once the request is made to the server, it starts doing what it
> has to do and runs until it's finished (or errors out, times out, whatever).
> Asuming that you cannot do anything about the duration of the database
> operations, perhaps you'll be interested in some of the ideas here.
> http://www.aspfaq.com/show.asp?id=2194
>
> Ray at work
>[/color]


Much appreciated.

Thanks Ray.

Colin