By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,152 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,152 IT Pros & Developers. It's quick & easy.

Help on Store procedure and ASP web page

P: n/a
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
Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 19 '05 #2

P: n/a
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

Nov 19 '05 #3

P: n/a
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


Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.