Timeout on my request!

[Smith]

Hello,
In my asp.net application i need to retreive data from my MS SQL db. The
query takes more then 3 minutes.
I get a timeout after about 30 seconds. I have change the sqlCommandTimeout
default value of the <sessionState to 12000 in web.config. I still get the
same timeout problem.

Does anyone know how i solve the timeout problem.

Thanks
Smith

[Mark Rae [MVP]]

"Smith" <Sm***@pricateemail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>
Hello,
In my asp.net application i need to retreive data from my MS SQL db. The
query takes more then 3 minutes.
I get a timeout after about 30 seconds. I have change the
sqlCommandTimeout default value of the <sessionState to 12000 in
web.config. I still get the same timeout problem.

Does anyone know how i solve the timeout problem.

How are you specifying the setting? Note that the sqlCommandTimeout
attribute is a TimeSpan attribute:
http://msdn2.microsoft.com/en-us/lib...z9(vs.80).aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Smith]

>

How are you specifying the setting? Note that the sqlCommandTimeout
attribute is a TimeSpan attribute:
http://msdn2.microsoft.com/en-us/lib...z9(vs.80).aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Below how i do it:

<sessionState

sqlCommandTimeout="12000"

cookieless="true"

timeout="20"

/>

Thanks

/S

[Mark Rae [MVP]]

"Smith" <Sm***@pricateemail.comwrote in message
news:uz**************@TK2MSFTNGP03.phx.gbl...

sqlCommandTimeout="12000"

Hmm - that's a *HUGE* amount of time to wait for results from a database
query... 12,000 seconds = 200 minutes = over 3 hours...

I'm not aware that the sqlCommandTimeout has a maximum value but, just in
case, have you tried setting it to something a bit more sensible e.g. 300 (=
5 minutes)...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Smith" <Sm***@pricateemail.comwrote in message
news:uS**************@TK2MSFTNGP04.phx.gbl...

It all depends on the kind of data you work with. We are looking at
scientifc data here.

Data is data is data, at the end of the day...

Some of our queries can span over several hours.

In which case, I would be considering a different architecture, as the web
simply isn't designed for this kind of delay between Request and Response...

Have you thought about maybe some sort of messaging system where queries are
queued up waiting to be processed, and then the results emailed to the user
maybe as a PDF...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Chuck Norris]

First, check the estimated execution plan of your query and, if it's
possible, try to optimize it.
If you have already done that,
why don't you schedule your query to run in background each night (or
each hour) and save the results in a DB table?
At this point in your web page do a simple 'select' statement to show
the data...surely it'll be faster.
:-)

On Sep 6, 3:40 pm, "Mark Rae [MVP]" <[e-mail]:

"Smith" <[e-mail] in message

news:uS**************@TK2MSFTNGP04.phx.gbl...

It all depends on the kind of data you work with. We are looking at
scientifc data here.

Data is data is data, at the end of the day...

Some of our queries can span over several hours.

In which case, I would be considering a different architecture, as the web
simply isn't designed for this kind of delay between Request and Response...

Have you thought about maybe some sort of messaging system where queries are
queued up waiting to be processed, and then the results emailed to the user
maybe as a PDF...?

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net

[Smith]

een Request and Response...

>
Have you thought about maybe some sort of messaging system where queries
are queued up waiting to be processed, and then the results emailed to the
user maybe as a PDF...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

I understand your concerns Mark. And you are right. I think i have to take
this up with management. Some of this does not really make sens in the web
world.
Users select a combination of data and we calculate what the asked for on
the DB server, then return the data.
Users are prompted with a pop up window with an estimation of the time the
computation will take. As i said earlier, we are working in the scientific
community. Users previously got an FTP link to the data and dowloaded. Now,
progress mean, the data can be streamed to them. The data is highly
compressable, so dowload is not a problem.

But i understand we need to review the architecture. And again, computation
has been gratly optimised on the DB server.

Cheers
Smith

[bruce barker]

you are changing the timeout on a session fetch, not a sqlquery, so it
has no impact. the SqlCommand you are using has a CommandTimeout
property you can set. you will also need to change the page timeout so
it doesn't timeout also.

three minutes is too long, the browser may give up, the user will. you
should start a background thread to do the query and have the browser
poll for completion.

-- bruce (sqlwork.com)

Smith wrote:

Hello,
In my asp.net application i need to retreive data from my MS SQL db. The
query takes more then 3 minutes.
I get a timeout after about 30 seconds. I have change the sqlCommandTimeout
default value of the <sessionState to 12000 in web.config. I still get the
same timeout problem.

Does anyone know how i solve the timeout problem.

Thanks
Smith

[Smith]

"bruce barker" <no****@nospam.comwrote in message
news:eA**************@TK2MSFTNGP06.phx.gbl...

you are changing the timeout on a session fetch, not a sqlquery, so it has
no impact. the SqlCommand you are using has a CommandTimeout property you
can set. you will also need to change the page timeout so it doesn't
timeout also.

three minutes is too long, the browser may give up, the user will. you
should start a background thread to do the query and have the browser poll
for completion.

-- bruce (sqlwork.com)

Hi Bruce,
could you please give an example of your CommandTimeout ?

Thanks
Smith