Timeout problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are experiencing timeout problems with 2 of the reports on our website at
present.
Basically what is happening is , we have a request to the SQL Server
database to run a stored procedure to return the data. Some of the requests
are quite complecated & we expect them to take some time so we have increased
our database & web timeouts to 600 secs in the web.config
<httpRuntime executionTimeout="600" />

We have run the stored procedures via Enterprise Manager on our test
platform & tuned them, one returns in 3.5 to 4 minutes the other sub 1
second, but when we run the reports via the web pages on the live system they
timeout .

I don't think it's the database timing out, although we can't test that 100%
as we don't have acess to it, but feel it's some issue with the web server.

Any advise on what may be causing the problem would be gratefully received.

Thanks,
John
 
I am assuming that the time out is a scripting timeout on your browser. As
a test, try this:

1. Have the server receive the request from the user, begin processing it
on another thread, return control back to the client (a progress display of
sorts.)

2. Have the client check on the status of the sql process every few
seconds, say every 15.

3. If the process is complete, display the results.
 
Back
Top