Hello,
I write a Web Application:
its UI has a DataGrid controller.
The web application gets huge data from SQL Server,
then shows the result after processing these data.
It needs much time to run it.
But, it happened an error after running less than 60 seconds.
This error didn't explain detail.
I set
Server.ScriptTimeout=600;
<httpRuntime executionTimeout="600" />
cmd.CommandTimeout=600;
But, it doesn't work.
It still has an error in 60 seconds.
How to solve it?
Thanks.
6  2922 
May your application have 60 seconds time out. which configured via IIS
manager. My advice you to test it using Response.BufferOutput is false. and
flush it at some count of records.
Also, i wonder if does it give a sql connection time out or ASP.NET timeout?
If it gives a sql connection time out, you must set timeout in your
connection string...
--
Thanks,
Yunus Emre ALPÖZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com... Hello,
I write a Web Application:
its UI has a DataGrid controller.
The web application gets huge data from SQL Server,
then shows the result after processing these data.
It needs much time to run it.
But, it happened an error after running less than 60 seconds.
This error didn't explain detail.
I set
Server.ScriptTimeout=600;
<httpRuntime executionTimeout="600" />
cmd.CommandTimeout=600;
But, it doesn't work.
It still has an error in 60 seconds.
How to solve it?
Thanks.
I don't configure the IIS setting.
I already set ScriptTimeout and SqlCommand's CommandTimeout, but it doesn't
work.
The Web Page only needs a DataGrid which shows the processing result.
So, I use Response.BufferOutput=false; , it still doesn't work.
ASP Web Page can use Server.ScriptTimeout to extend running time,
but ASP.NET seems no work for it.
I think ASP.NET should have this function, but I don't find it until now.
If you have other suggestions, please kindly tell me.
Thanks.
"Yunus Emre ALPĂ–ZEN" wrote: May your application have 60 seconds time out. which configured via IIS
manager. My advice you to test it using Response.BufferOutput is false. and
flush it at some count of records.
Also, i wonder if does it give a sql connection time out or ASP.NET timeout?
If it gives a sql connection time out, you must set timeout in your
connection string...
--
Thanks,
Yunus Emre ALPĂ–ZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com... Hello,
I write a Web Application:
its UI has a DataGrid controller.
The web application gets huge data from SQL Server,
then shows the result after processing these data.
It needs much time to run it.
But, it happened an error after running less than 60 seconds.
This error didn't explain detail.
I set
Server.ScriptTimeout=600;
<httpRuntime executionTimeout="600" />
cmd.CommandTimeout=600;
But, it doesn't work.
It still has an error in 60 seconds.
How to solve it?
Thanks.
Does your exception is thrown by SQL server or ASP.NET? Also if you set your
connection string timeout may your connection expire...
--
Thanks,
Yunus Emre ALPÖZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:F5**********************************@microsof t.com... I don't configure the IIS setting.
I already set ScriptTimeout and SqlCommand's CommandTimeout, but it
doesn't
work.
The Web Page only needs a DataGrid which shows the processing result.
So, I use Response.BufferOutput=false; , it still doesn't work.
ASP Web Page can use Server.ScriptTimeout to extend running time,
but ASP.NET seems no work for it.
I think ASP.NET should have this function, but I don't find it until now.
If you have other suggestions, please kindly tell me.
Thanks.
"Yunus Emre ALPÖZEN" wrote:
May your application have 60 seconds time out. which configured via IIS
manager. My advice you to test it using Response.BufferOutput is false.
and
flush it at some count of records.
Also, i wonder if does it give a sql connection time out or ASP.NET
timeout?
If it gives a sql connection time out, you must set timeout in your
connection string...
--
Thanks,
Yunus Emre ALPÖZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com... > Hello,
> I write a Web Application:
> its UI has a DataGrid controller.
> The web application gets huge data from SQL Server,
> then shows the result after processing these data.
>
> It needs much time to run it.
> But, it happened an error after running less than 60 seconds.
> This error didn't explain detail.
> I set
> Server.ScriptTimeout=600;
> <httpRuntime executionTimeout="600" />
> cmd.CommandTimeout=600;
> But, it doesn't work.
> It still has an error in 60 seconds.
>
> How to solve it?
> Thanks.
>
Just a thought, but from my experience, any query result that takes more
than 60 seconds to return might be way too big to send to a web page.
How much data are you returning? Could you reduce the time to return the
data by tuning and optimizing your query? Do you have the appropriate
indexes, etc?
DalePres
MCAD, MCDBA, MCSE
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com... Hello,
I write a Web Application:
its UI has a DataGrid controller.
The web application gets huge data from SQL Server,
then shows the result after processing these data.
It needs much time to run it.
But, it happened an error after running less than 60 seconds.
This error didn't explain detail.
I set
Server.ScriptTimeout=600;
<httpRuntime executionTimeout="600" />
cmd.CommandTimeout=600;
But, it doesn't work.
It still has an error in 60 seconds.
How to solve it?
Thanks.
It doesn't figure out what reason.
But, the data in the SQL Server is little, it could get the result.
If the data is large, it will interrupt the execution.
I Guess that it must run a long time, but ASP.NET doesn't allow it.
Even though I set ScriptTimeout and CommandTimeout, it still doesn't extend
the execution time.
But, I think ASP.NET must can do it, only I don't know what to do.
"Yunus Emre ALPĂ–ZEN" wrote: Does your exception is thrown by SQL server or ASP.NET? Also if you set your
connection string timeout may your connection expire...
--
Thanks,
Yunus Emre ALPĂ–ZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:F5**********************************@microsof t.com...I don't configure the IIS setting.
I already set ScriptTimeout and SqlCommand's CommandTimeout, but it
doesn't
work.
The Web Page only needs a DataGrid which shows the processing result.
So, I use Response.BufferOutput=false; , it still doesn't work.
ASP Web Page can use Server.ScriptTimeout to extend running time,
but ASP.NET seems no work for it.
I think ASP.NET should have this function, but I don't find it until now.
If you have other suggestions, please kindly tell me.
Thanks.
"Yunus Emre ALPĂ–ZEN" wrote:
May your application have 60 seconds time out. which configured via IIS
manager. My advice you to test it using Response.BufferOutput is false.
and
flush it at some count of records.
Also, i wonder if does it give a sql connection time out or ASP.NET
timeout?
If it gives a sql connection time out, you must set timeout in your
connection string...
--
Thanks,
Yunus Emre ALPĂ–ZEN
"Grace" <Gr***@discussions.microsoft.com> wrote in message
news:9E**********************************@microsof t.com...
> Hello,
> I write a Web Application:
> its UI has a DataGrid controller.
> The web application gets huge data from SQL Server,
> then shows the result after processing these data.
>
> It needs much time to run it.
> But, it happened an error after running less than 60 seconds.
> This error didn't explain detail.
> I set
> Server.ScriptTimeout=600;
> <httpRuntime executionTimeout="600" />
> cmd.CommandTimeout=600;
> But, it doesn't work.
> It still has an error in 60 seconds.
>
> How to solve it?
> Thanks.
>
Grace wrote: Hello,
I write a Web Application:
its UI has a DataGrid controller.
The web application gets huge data from SQL Server,
then shows the result after processing these data.
It needs much time to run it.
But, it happened an error after running less than 60 seconds.
This error didn't explain detail.
I set
Server.ScriptTimeout=600;
<httpRuntime executionTimeout="600" />
cmd.CommandTimeout=600;
But, it doesn't work.
It still has an error in 60 seconds.
How to solve it?
You could run the query in background and put the result into Cache or
Application State.
ASP.NET doesn't provide anything like servlet, but since the
HttpApplication (global.asax) is not restarted per request, you may use
it for the purpose. Just override HttpApplication.Init() to setup a
thread for such tasks. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mike Chamberlain |
last post by:
Hi all.
I'm trying to extend the Microsoft Enterprise Library Data Access
Application Block
(http://msdn.microsoft.com/library/en-us/dnpag2/html/daab.asp?frame=true)
to work with a Borland...
|
by: Jerzy Karczmarczuk |
last post by:
Gurus, before I am tempted to signal this as a bug, perhaps
you might convince me that it should be so. If I type
l=range(4)
l.extend()
l gives , what else...
On the other hand, try
|
by: Boobie |
last post by:
I switched to using this function to create element:
----------------------------------------------------
function elem(name, attrs, style, text) {
var e = document.createElement(name);
if...
|
by: nickdu |
last post by:
I'm trying to isolate "applications" into their own application domain within
a single process. I've quoted applications because it's a logical
representation of an application. Basically it...
|
by: Sharon |
last post by:
I have an application that fails to allocate all its memory on physical memory.
I have a Windows XP with 2 GByte RAM.
Can anybody tell me how to configure the allowed physical memory for each...
| | |
by: Uma |
last post by:
Dear all,
I have a problem while running a smart client application which was
installed through CD-ROM. After installing the smart client setup the
application is running properly. When running...
|
by: eXt |
last post by:
For a realtime-application (half an application at least, kind of a
framework) I am working with I need a event managing system and
naturally it must be fast. I have defined a set of available...
|
by: Lloyd Dupont |
last post by:
I have an application with produce document/file with a lot of textual
information into it (in a TAR-GZ format).
This application is for the general public (as opposed to corporate, so I
cannot...
|
by: jacobstr |
last post by:
I've noticed Object.extend used in a few different ways and I'm having
trouble distinguishing why certain usages apply to a given situation.
On line 804 Ajax.Base is defined as follows:
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
