Timeout problems

[=?Utf-8?B?Sm9obiBDbGVubmV0dA==?=]

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 executionTimeou t="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

[AMDRIT]

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.

"John Clennett" <John Cl******@discus sions.microsoft .comwrote in message
news:9A******** *************** ***********@mic rosoft.com...

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 executionTimeou t="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