Help on Store procedure and ASP web page

[serge calderara]

Dear all,

One simple question relative to store procedure withinh ASP code on a web
page.
Let say that I am calling a store procedure to execute from a server button
click on my web page. That store procedure is returning a bunch of values to
my end user.

In a matter of time based, what happen from my client web page if my store
procedure runs for 3 minutes before returning any data back.

Does the web page execution works synchronously or asynchronously in that
case ?
Does my web application will be stuck for 3 minutes ?

regards
serge

[Oleg Kap]

Hello serge,
Yes, potentially you page will be hung for 3 minutes, but usully your script
will time out long before that, default 90 seconds.
You might look into using AJAX to perform long time task and then when its
ready to present user with result.

Hope it helps,
Oleg

Dear all,

One simple question relative to store procedure withinh ASP code on a
web
page.
Let say that I am calling a store procedure to execute from a server
button
click on my web page. That store procedure is returning a bunch of
values to
my end user.
In a matter of time based, what happen from my client web page if my
store procedure runs for 3 minutes before returning any data back.

Does the web page execution works synchronously or asynchronously in
that
case ?
Does my web application will be stuck for 3 minutes ?
regards
serge

[Karl Seguin]

By default it runs synchronously, so yes the REQUEST is stuck for 3 minutes,
not the entire web application (ie, other requests, which come on a separate
thread, won't be blocked).

A good solution might be....drum roll....Ajax :)
http://msdn.microsoft.com/library/de...SpicedAjax.asp

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/

"serge calderara" <se************@discussions.microsoft.com> wrote in
message news:7D**********************************@microsof t.com...

Dear all,

One simple question relative to store procedure withinh ASP code on a web
page.
Let say that I am calling a store procedure to execute from a server
button
click on my web page. That store procedure is returning a bunch of values
to
my end user.

In a matter of time based, what happen from my client web page if my store
procedure runs for 3 minutes before returning any data back.

Does the web page execution works synchronously or asynchronously in that
case ?
Does my web application will be stuck for 3 minutes ?

regards
serge

[serge calderara]

How usually people handle the fact that a database can contains a huge amount
of data which could run over the time out ?

Do they fetch the data in 2 or 3 steps ?

What is this AJAX ?

I ma new in ASP sorry

"Oleg Kap" wrote:

Hello serge,
Yes, potentially you page will be hung for 3 minutes, but usully your script
will time out long before that, default 90 seconds.
You might look into using AJAX to perform long time task and then when its
ready to present user with result.

Hope it helps,
Oleg

Dear all,

One simple question relative to store procedure withinh ASP code on a
web
page.
Let say that I am calling a store procedure to execute from a server
button
click on my web page. That store procedure is returning a bunch of
values to
my end user.
In a matter of time based, what happen from my client web page if my
store procedure runs for 3 minutes before returning any data back.

Does the web page execution works synchronously or asynchronously in
that
case ?
Does my web application will be stuck for 3 minutes ?
regards
serge