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
4  1472 
//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*******@gmai l.comwrote in message
news:em******** ******@TK2MSFTN GP04.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
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*******@gmai l.comwrote in message
news:em******** ******@TK2MSFTN GP04.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
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*****@discus sions.microsoft .comwrote in message
news:AF******** *************** ***********@mic rosoft.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.GetX ml 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*******@gmai l.comwrote in message
news:em******* *******@TK2MSFT NGP04.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
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*****@discus sions.microsoft .comwrote in message
news:AF******** *************** ***********@mic rosoft.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*******@gmai l.comwrote in message
news:em******** ******@TK2MSFTN GP04.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 logging out? i.e: using the "X" in the right corner???
i'd like to reset to their default all my variables session?? is this
possible???
2: I've succesfully been able to ask the user to confirm whether he
wants to extend his session before it...
|
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 Timed out) I am using the
Data Access Application Blocks as ASP.NET (using VB.NET) and SQL 2000.
In there first question there can be up to 27 answers. So I figured
instead of making 27 different trips to the database I woulc just
concatenate my...
|
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 |
Properties | Configuration | Options | Enable Session State
Session timeout 20
(3) within Global.asax.vb file - Session_Start subroutine can use
Session.Timeout=x minutes or
(4) within any web page, i.e., <web page>.aspx can use...
|
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 question is if the session expires,
would the above statement produce any exception? If I can't find the
ProposalId value in the session object, I would like to display a message to
the user and close the window.
|
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 connection = new
SqlConnection(ConfigurationSettings.AppSettings))
{
| | |
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 considered?
Besides, could anyone differentiate the timeout attributes between the
lines marked with astericks?
<sessionState mode="InProc" cookieless="false" timeout="180"/> **
|
by: A.M-SG |
last post by:
Hi,
How can I increase the HTTP Timeout value at the client side?
Thank you,
Alan
|
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 recall it didn't like the parenthesis (). I got rid of them,
and it worked. What is the reasoning behind this? When are you
supposed to add the () ?
|
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?.
Heres my code:
var xmlhttp = false ;
if (!xmlhttp && typeof XMLHttpRequest != 'undefined')
{
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
