473,320 Members | 1,920 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,320 software developers and data experts.

Simple Timeout Question

How can I see/set the timeout for a postback? I have a button click event
which loops through a DataSet and calls a stored procedure for every record
in the dataset. This can be a very large number, and locally it's working
fine. However, when I move to our development server, the exact same code
pointing to the same database redirects to a Page Cannot Be Displayed after
a finite period of time. I'd like to bump up the "timeout" if possible, but
I'm not sure where to do it. It's not the duration of the specific command
I'm worried about, it's the sheer number of calls.

Thanks
Oct 17 '06 #1
4 1452
//Quote
which loops through a DataSet and calls a stored procedure for every record
in the dataset.
//End Quote

Youch.

I'm not going to give a "How to increase the Timeout" answer.
I'm going to give a "rethink that approach" answer.

If you're using Sql Server (or maybe Oracle, though I'm not a big fan of
Oracle Xml usage), you can pass in the entire
DataSet.GetXml into the stored procedure............
and process once inside the stored procedure.

If you have an index(indices) on any tables that you're updating, the Index
is being rebuilt after each and every stored procedure call.
Aka, 1000 rows in your dataset, 1000 index rebuilds.

Using the DataSet.GetXml approach, 1000 inserts = 1 index rebuild. 1000
updates = 1 index rebuild.
1000 inserts + 1000 updates = 2 index rebuilds.
You can find how to work with DataSet.GetXml
starting here:
http://www.sqlservercentral.com/colu...terproblem.asp
and
http://support.microsoft.com/?kbid=315968


"James" <mi*******@gmail.comwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
How can I see/set the timeout for a postback? I have a button click event
which loops through a DataSet and calls a stored procedure for every
record
in the dataset. This can be a very large number, and locally it's working
fine. However, when I move to our development server, the exact same code
pointing to the same database redirects to a Page Cannot Be Displayed
after
a finite period of time. I'd like to bump up the "timeout" if possible,
but
I'm not sure where to do it. It's not the duration of the specific
command
I'm worried about, it's the sheer number of calls.

Thanks


Oct 17 '06 #2
i agree with sloan, also you can look at using atlas for queries that take a
long time, look at the cutting edge article on the msdn magazine:

http://msdn.microsoft.com/msdnmag/is...e/default.aspx

--
The walls between art and engineering exist only in our minds
"sloan" wrote:
//Quote
which loops through a DataSet and calls a stored procedure for every record
in the dataset.
//End Quote

Youch.

I'm not going to give a "How to increase the Timeout" answer.
I'm going to give a "rethink that approach" answer.

If you're using Sql Server (or maybe Oracle, though I'm not a big fan of
Oracle Xml usage), you can pass in the entire
DataSet.GetXml into the stored procedure............
and process once inside the stored procedure.

If you have an index(indices) on any tables that you're updating, the Index
is being rebuilt after each and every stored procedure call.
Aka, 1000 rows in your dataset, 1000 index rebuilds.

Using the DataSet.GetXml approach, 1000 inserts = 1 index rebuild. 1000
updates = 1 index rebuild.
1000 inserts + 1000 updates = 2 index rebuilds.
You can find how to work with DataSet.GetXml
starting here:
http://www.sqlservercentral.com/colu...terproblem.asp
and
http://support.microsoft.com/?kbid=315968


"James" <mi*******@gmail.comwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
How can I see/set the timeout for a postback? I have a button click event
which loops through a DataSet and calls a stored procedure for every
record
in the dataset. This can be a very large number, and locally it's working
fine. However, when I move to our development server, the exact same code
pointing to the same database redirects to a Page Cannot Be Displayed
after
a finite period of time. I'd like to bump up the "timeout" if possible,
but
I'm not sure where to do it. It's not the duration of the specific
command
I'm worried about, it's the sheer number of calls.

Thanks


Oct 17 '06 #3
Understood, obviously...but I have no control over said stored
procedure/database. I'm also unable to bargain with those responsible for
aforementioned structure. I'm stuck dealing with what I have,
unfortunately.

"Halcyon" <Ha*****@discussions.microsoft.comwrote in message
news:AF**********************************@microsof t.com...
>i agree with sloan, also you can look at using atlas for queries that take
a
long time, look at the cutting edge article on the msdn magazine:

http://msdn.microsoft.com/msdnmag/is...e/default.aspx

--
The walls between art and engineering exist only in our minds
"sloan" wrote:
>//Quote
which loops through a DataSet and calls a stored procedure for every
record
in the dataset.
//End Quote

Youch.

I'm not going to give a "How to increase the Timeout" answer.
I'm going to give a "rethink that approach" answer.

If you're using Sql Server (or maybe Oracle, though I'm not a big fan of
Oracle Xml usage), you can pass in the entire
DataSet.GetXml into the stored procedure............
and process once inside the stored procedure.

If you have an index(indices) on any tables that you're updating, the
Index
is being rebuilt after each and every stored procedure call.
Aka, 1000 rows in your dataset, 1000 index rebuilds.

Using the DataSet.GetXml approach, 1000 inserts = 1 index rebuild. 1000
updates = 1 index rebuild.
1000 inserts + 1000 updates = 2 index rebuilds.
You can find how to work with DataSet.GetXml
starting here:
http://www.sqlservercentral.com/colu...terproblem.asp
and
http://support.microsoft.com/?kbid=315968


"James" <mi*******@gmail.comwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
How can I see/set the timeout for a postback? I have a button click
event
which loops through a DataSet and calls a stored procedure for every
record
in the dataset. This can be a very large number, and locally it's
working
fine. However, when I move to our development server, the exact same
code
pointing to the same database redirects to a Page Cannot Be Displayed
after
a finite period of time. I'd like to bump up the "timeout" if
possible,
but
I'm not sure where to do it. It's not the duration of the specific
command
I'm worried about, it's the sheer number of calls.

Thanks




Oct 17 '06 #4
mkay, are you able to use atlas?

i use it for a web based software metering application that can take hours
to complete and it can take hours to complete, the atlas approach worked for
me, lemme know if it grafts for you ; )

--
The walls between art and engineering exist only in our minds
"James" wrote:
Understood, obviously...but I have no control over said stored
procedure/database. I'm also unable to bargain with those responsible for
aforementioned structure. I'm stuck dealing with what I have,
unfortunately.

"Halcyon" <Ha*****@discussions.microsoft.comwrote in message
news:AF**********************************@microsof t.com...
i agree with sloan, also you can look at using atlas for queries that take
a
long time, look at the cutting edge article on the msdn magazine:

http://msdn.microsoft.com/msdnmag/is...e/default.aspx

--
The walls between art and engineering exist only in our minds
"sloan" wrote:
//Quote
which loops through a DataSet and calls a stored procedure for every
record
in the dataset.
//End Quote

Youch.

I'm not going to give a "How to increase the Timeout" answer.
I'm going to give a "rethink that approach" answer.

If you're using Sql Server (or maybe Oracle, though I'm not a big fan of
Oracle Xml usage), you can pass in the entire
DataSet.GetXml into the stored procedure............
and process once inside the stored procedure.

If you have an index(indices) on any tables that you're updating, the
Index
is being rebuilt after each and every stored procedure call.
Aka, 1000 rows in your dataset, 1000 index rebuilds.

Using the DataSet.GetXml approach, 1000 inserts = 1 index rebuild. 1000
updates = 1 index rebuild.
1000 inserts + 1000 updates = 2 index rebuilds.
You can find how to work with DataSet.GetXml
starting here:
http://www.sqlservercentral.com/colu...terproblem.asp
and
http://support.microsoft.com/?kbid=315968


"James" <mi*******@gmail.comwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
How can I see/set the timeout for a postback? I have a button click
event
which loops through a DataSet and calls a stored procedure for every
record
in the dataset. This can be a very large number, and locally it's
working
fine. However, when I move to our development server, the exact same
code
pointing to the same database redirects to a Page Cannot Be Displayed
after
a finite period of time. I'd like to bump up the "timeout" if
possible,
but
I'm not sure where to do it. It's not the duration of the specific
command
I'm worried about, it's the sheer number of calls.

Thanks




Oct 17 '06 #5

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

Similar topics

4
by: HolaGoogle | last post by:
hi there, i've 2 questions for you guys.... 1: is there any way to "force" a session_onend(), session timeout or at least call my logout method when a user leaves the application window without...
3
by: DarthMacgyver | last post by:
Hello, I recently wrote a survey application. Each question is very similar. The first questions gives me a problem when there are multiple people taking the survey (The Database connection...
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...
7
by: Nikhil Patel | last post by:
Hi all, I am using a Session object in my ASP.Net application to store a value of a Database field. I can access it as ... int iProposalId = Session; The session timeout is set to 20. Now my...
3
by: Nils Magnus Englund | last post by:
Hi, I've made a HttpModule which deals with user authentication. On the first request in a users session, it fetches data from a SQL Server using the following code: using (SqlConnection...
1
by: sri_san | last post by:
Hello, I was unable to find a concrete pointer as to the precedence of IIS, Web.config when it comes to timeout. Say, IIS has a timeout value set different from that of web.config, which one is...
4
by: A.M-SG | last post by:
Hi, How can I increase the HTTP Timeout value at the client side? Thank you, Alan
12
by: ed | last post by:
Hi there, I just remembered this from a few days ago, and was looking for a reason for it. I was trying to call a function as so: addEvent( whatever, whatever, functionName() ); and as I...
20
by: Bryan A | last post by:
Is there a way to add a timeout to this script so that it times out at a certain time. So it would be auto updating every 2seconds and it would timeout like after 100 seconds with a message?. ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
0
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: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.