473,322 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

ASP Timeout?

I have an asp page that is producing a report via some heavy SQL queries with
dynamically chosen parameters from the users of the page. I can run it on my
development server (takes about 35 minutes to produce) , however when it is
run on the production server it will execute for about 3 minutes, then bring
me to a Page Cannot Be Displayed. I think this might be some sort of
timeout, but I have no idea as to how to stop it. I've changed the timeout
property of the Server, I have even put in a buffer flush if the client
isConnected. However, none of this seems to help. Any ideas and
suggestions would be greatly helpful.
Jul 22 '05 #1
7 4086
Short answer...dont do it.
If the page takes that long to build you need to rethink what you are
doing. I suggest a server process to generate the results, run every (n)
min where the reult is accessed from the page. WWW isnt a good medium
for long running processes. Otherwise, I would think maybe find a way to
optimize the query (indexes, etc).

Beyond that, have you tried increasing the connection timeout or the
page timeout settings?

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

Tyler@Thomson wrote:
I have an asp page that is producing a report via some heavy SQL queries with
dynamically chosen parameters from the users of the page. I can run it on my
development server (takes about 35 minutes to produce) , however when it is
run on the production server it will execute for about 3 minutes, then bring
me to a Page Cannot Be Displayed. I think this might be some sort of
timeout, but I have no idea as to how to stop it. I've changed the timeout
property of the Server, I have even put in a buffer flush if the client
isConnected. However, none of this seems to help. Any ideas and
suggestions would be greatly helpful.

Jul 22 '05 #2
Unfortunately, I need to do this. It is for an internal app that I'm
developing while I'm on co-op. I've set the timeouts to be substantially
large, and they shouldn't be causing any problems. The adminstrators on the
server end aren't much help in letting me know why I would be getting this
error.

As for optimizing the query, I've begun that long and arduous task, working
with the DBA. Unfortunately, though, a lot of it doesn't seem that it can be
cut out or tuned. I was pretty sure that there wouldn't be much of a way
around this aside from tuning the queries. Thanks, and if you have any more
advice, send it my way.

"Curt_C [MVP]" wrote:
Short answer...dont do it.
If the page takes that long to build you need to rethink what you are
doing. I suggest a server process to generate the results, run every (n)
min where the reult is accessed from the page. WWW isnt a good medium
for long running processes. Otherwise, I would think maybe find a way to
optimize the query (indexes, etc).

Beyond that, have you tried increasing the connection timeout or the
page timeout settings?

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

Tyler@Thomson wrote:
I have an asp page that is producing a report via some heavy SQL queries with
dynamically chosen parameters from the users of the page. I can run it on my
development server (takes about 35 minutes to produce) , however when it is
run on the production server it will execute for about 3 minutes, then bring
me to a Page Cannot Be Displayed. I think this might be some sort of
timeout, but I have no idea as to how to stop it. I've changed the timeout
property of the Server, I have even put in a buffer flush if the client
isConnected. However, none of this seems to help. Any ideas and
suggestions would be greatly helpful.

Jul 22 '05 #3
What is the actual error message?

--
--Mark Schupp
"Tyler@Thomson" <Tyler@Th*****@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
I have an asp page that is producing a report via some heavy SQL queries
with
dynamically chosen parameters from the users of the page. I can run it on
my
development server (takes about 35 minutes to produce) , however when it
is
run on the production server it will execute for about 3 minutes, then
bring
me to a Page Cannot Be Displayed. I think this might be some sort of
timeout, but I have no idea as to how to stop it. I've changed the
timeout
property of the Server, I have even put in a buffer flush if the client
isConnected. However, none of this seems to help. Any ideas and
suggestions would be greatly helpful.

Jul 22 '05 #4
There is no specific error message--I'm just brought to a "Page Cannont be
Displayed" page. I don't really know why this would be occurring, though I
suspect it might be some sort of timeout, but again, that doesn't make any
sense considering I have taken the proper steps to guard against that
happening. However, if there are any other possible causes and solutions,
then that would be greatly apprecitated. Hopefully I cleared things up a bit.

"Mark Schupp" wrote:
What is the actual error message?

--
--Mark Schupp
"Tyler@Thomson" <Tyler@Th*****@discussions.microsoft.com> wrote in message
news:46**********************************@microsof t.com...
I have an asp page that is producing a report via some heavy SQL queries
with
dynamically chosen parameters from the users of the page. I can run it on
my
development server (takes about 35 minutes to produce) , however when it
is
run on the production server it will execute for about 3 minutes, then
bring
me to a Page Cannot Be Displayed. I think this might be some sort of
timeout, but I have no idea as to how to stop it. I've changed the
timeout
property of the Server, I have even put in a buffer flush if the client
isConnected. However, none of this seems to help. Any ideas and
suggestions would be greatly helpful.


Jul 22 '05 #5
Turn off Friendly Errors so you can see the real error message:
http://www.aspfaq.com/show.asp?id=2109

There are two timeouts that you need to be concerned with:
ScriptTimeout - set via the website properties in IIS Mgr or via the Server
object in your code

ADO's CommandTimeout property - set either on the Connection object or on
the Command object being yused to run yor command. Do a search at
msdn.microsoft.com/library for details

Bob Barrows
Tyler@Thomson wrote:
There is no specific error message--I'm just brought to a "Page
Cannont be Displayed" page. I don't really know why this would be
occurring, though I suspect it might be some sort of timeout, but
again, that doesn't make any sense considering I have taken the
proper steps to guard against that happening. However, if there are
any other possible causes and solutions, then that would be greatly
apprecitated. Hopefully I cleared things up a bit.

"Mark Schupp" wrote:
What is the actual error message?


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 22 '05 #6
Tyler@Thomson wrote:
I have an asp page that is producing a report via some heavy SQL
queries with dynamically chosen parameters from the users of the
page. I can run it on my development server (takes about 35 minutes
to produce) , however when it is run on the production server it will
execute for about 3 minutes, then bring me to a Page Cannot Be
Displayed...


Is the production machine IIS6? If so, consider using a separate Application
Pool for this process.

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Jul 22 '05 #7
I have shut off friendly errors on my machine, and I've contacted the server
"people" (I'm not sure if they know what they're doing a lot of the time)
because my settings still seem to show the Page cannot be displayed message.
Also, I have set the script timeout to a very large number and the ADO
commandtimeout property to 0, which should effectively allow me to wait
indefinately for this thing to run. The strangest thing is that it will run
on the development server (my machine), but it won't seem to run on the
production server, giving me this problem. I hope that clears anything up.

"Bob Barrows [MVP]" wrote:
Turn off Friendly Errors so you can see the real error message:
http://www.aspfaq.com/show.asp?id=2109

There are two timeouts that you need to be concerned with:
ScriptTimeout - set via the website properties in IIS Mgr or via the Server
object in your code

ADO's CommandTimeout property - set either on the Connection object or on
the Command object being yused to run yor command. Do a search at
msdn.microsoft.com/library for details

Bob Barrows
Tyler@Thomson wrote:
There is no specific error message--I'm just brought to a "Page
Cannont be Displayed" page. I don't really know why this would be
occurring, though I suspect it might be some sort of timeout, but
again, that doesn't make any sense considering I have taken the
proper steps to guard against that happening. However, if there are
any other possible causes and solutions, then that would be greatly
apprecitated. Hopefully I cleared things up a bit.

"Mark Schupp" wrote:
What is the actual error message?


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 22 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: E Sullivan | last post by:
I am having a time out issue when multiple users are accessing the server. This time out does not happen all of the time. My understanding is that the time out value is actually set in two places....
12
by: Geigho | last post by:
Setting session timeout in web.config file does not seem to have any effect. Any explanation or suggestion will be appreciated.
2
by: Greg Decos | last post by:
I am using forms authentication using a FormsAuthenticationTickets set to expire in 30 minutes and the ticket is added to the collection of cookies. I am not sure where the following values are...
4
by: DavidS | last post by:
First: There are several ways to confuse one regarding session timeout. (1) web.config - <sessionState timeout="20"> (2) IIS Manager | Internet Information Services | ServerNode | Default Web Site...
17
by: jensen bredal | last post by:
Hello, i'm struggling with a somehow badly understood session scenario. I provide acces to my pages based on form authentication using Session cookies. Som of my pages are supposed to be...
4
by: UJ | last post by:
I have a page where the user can upload a video file. As you can guess, this may take a while. Is there a way I can change the session timeout for just this one page? I would also want to change...
22
by: Nick Craig-Wood | last post by:
Did anyone write a contextmanager implementing a timeout for python2.5? I'd love to be able to write something like with timeout(5.0) as exceeded: some_long_running_stuff() if exceeded:...
25
by: =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= | last post by:
I tried: <sessionState timeout="1"> </sessionState> bounced IIS, and after 1 minute still had a session. ??? -- thanks - dave
5
by: Masso | last post by:
Hallo to the group, my question is this: where i have to set timeout in a web application? If i set into sessionState with property Timeout="60", after 20 minutes the session is over. Always...
2
by: JimLad | last post by:
Hi, I've got a very basic asp.net page that accesses a very slow db query and siplays to screen. I'm hitting a timeout aftre about 3.5 to 4.5 minutes - seems to be variable. SQL connection...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.