|
 |
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!!!
|
|
 |