Re: Timeout problems

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 Clennett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9ACCE70A-1DD4-4CF7-862A-3490875F730B@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Database index is corruption . I dont know how to explain to my client]
    ... IF this data resides on the server - then use a server based anti-virus ... > I told my client the database index is corruption due to some client PC ... > effected by client computer even the client computer was hang or had ... > sending a request to server to ask for data modification. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: StreamWrite / Problem?
    ... Server Error in '/MySite' Application. ... IUSR_MACHINENAME) or the authenticated request user. ... > the database doesn't allow connections ... >> Public Shared Sub LogError ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: how to handle socket timeout?
    ... The notion of "fast" is configurable by the timeout value. ... The server became unreachable. ... TCP is a reliable bytestream protocol based on ... etc), send a request using UDP when you want to request some data, ...
    (comp.unix.programmer)
  • Re: Fehler "Der gefundene Anforderungstyp ist text/html; charset=utf-8, aber text/xml wurde erw
    ... Was sind denn in dieser Konstellation sinnvoll Werte für das Timeout? ... Das lässt sich nicht so allgemein sagen, da es vom Umfang der Seiten abhängt ... Request 15 Sekunden braucht, ... Dann schwitzt der Server schon recht. ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Database index is corruption . I dont know how to explain to my client]
    ... I told my client the database index is corruption due to some client PC ... The data of the shipping program is stored in server and client computer is ... sending a request to server to ask for data modification. ...
    (microsoft.public.fox.programmer.exchange)