Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Timeout issues


Message #1 by "Joe Ehrenfeld" <joee@v...> on Mon, 17 Sep 2001 15:50:24
I have a web process that lets the user ship out orders. When the user 

ships I have an asp page that updates and inserts 12 different tables. Our 

Oracle database is large, full of data. And depending on the time of day 

the updating of the tables can take anywhere from one minute to three 

minutes. I have increased the session timeout on the server, but still the 

user has to sit there until the process is completed. What I would like to 

do is lets say I have 200 records to update. I want to update 50 records 

at a time. When the first 50 are updated I would like my asp page to show 

the user that 50 have been updated and that we are updating the next 50. 

Then the asp page updates the next 50. Keep doing this until all records 

have been updated. When all has been updated I will show a message to the 

user that all records have been updated successfully. 



If this is not feasble and will not fix the timeout issue is there a way 

to have the user go to another screen while the shipping process is done 

in the background? If there is any problems with the shipping process send 

an email to someone.



Thanks so much!!!
Message #2 by "phil griffiths" <pgtips@m...> on Tue, 18 Sep 2001 10:13:50
Isn't this exactly what Response.Flush does?



> I have a web process that lets the user ship out orders. When the user 

> ships I have an asp page that updates and inserts 12 different tables. 

Our 

> Oracle database is large, full of data. And depending on the time of day 

> the updating of the tables can take anywhere from one minute to three 

> minutes. I have increased the session timeout on the server, but still 

the 

> user has to sit there until the process is completed. What I would like 

to 

> do is lets say I have 200 records to update. I want to update 50 records 

> at a time. When the first 50 are updated I would like my asp page to 

show 

> the user that 50 have been updated and that we are updating the next 50. 

> Then the asp page updates the next 50. Keep doing this until all records 

> have been updated. When all has been updated I will show a message to 

the 

> user that all records have been updated successfully. 

> 

> If this is not feasble and will not fix the timeout issue is there a way 

> to have the user go to another screen while the shipping process is done 

> in the background? If there is any problems with the shipping process 

send 

> an email to someone.

> 

> Thanks so much!!!

  Return to Index