ASP .NET - timeout error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

timeout error

AVL

2008-02-28, 8:17 pm

Hi,
I've a method in my web service..which makes a call to db
and sends back a dataset..
the query takes 2 mins to fetch the results..by that time i'm seeing a
'operation has timed out error' on my screen..

is there any to get rid of this error?

bruce barker

2008-02-28, 8:17 pm

you woudl need to up the page timeout and the sqlcommand timeout. but this is
a bad idea. if you can not get the query to run in under a couple seconds,
then you shoudl starta background thread to do the query, and poll for the
results. holding browser connections open for minutes is just asking for
trouble.

-- bruce (sqlwork.com)

"AVL" wrote:

> Hi,
> I've a method in my web service..which makes a call to db
> and sends back a dataset..
> the query takes 2 mins to fetch the results..by that time i'm seeing a
> 'operation has timed out error' on my screen..
>
> is there any to get rid of this error?

Sponsored Links