|
You should use the SqlConnection.ConnectionTimeout property to adjust the timeout time of the connection. Here[^] is the MSDN page which gives some examples.
Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
What is the physical nature of your network that makes you think that is necessary?
|
|
|
|
|
Why would the network have anything to do with the connection timeout requirements?
If he is running a long stored proc then the timeout is relevant on the connection and the network latency is irrelevant.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Is that not CommandTimeout?
|
|
|
|
|
I beleive there is a difference but would have to look it up, probably the command timeout is effective for the current command where a connection timeout is for all commands on the connection.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
On the app I wrote for working with large datasets that can take over an hour to process certain fetch events, I have set my connection timeout to 5 seconds, and the command timeout to 0 (ie never timeout). works a treat.
|
|
|
|
|
Sure but that has nothing to do with the network 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thats why you confused me with this;
Mycroft Holmes wrote: If he is running a long stored proc then the timeout is relevant on the connection
The long running should be on the command, not the connection, or you should have said irrelevant on the connection.
Anyway, doesn't matter, we'll leave it there, I need a cuppa...... 
|
|
|
|
|
Mycroft Holmes wrote: Why would the network have anything to do with the connection timeout
requirements?
What other enterprise constraint would require changing it?
|
|
|
|
|
You seem to have taken a severe left turn, the OP was asking about how to change the connection timeout and you are now pursuing enterprise level network information. The guy may be working on a single user, personal application he is learning on (considering it is VB this is even more likely) and needs to cope with a long running stored procedure.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: and needs to cope with a long running stored procedure.
And changing the connection timeout is going to impact that?
|
|
|
|
|
Is it possible to change the tablespace for new (system-generated) partitions in a Range partitioned table after the table has been created? Thank you.
|
|
|
|
|
Hi,
Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day.
Regards.
|
|
|
|
|
What do you mean by partitioning a table? Filtering,sorting?
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Partitioning. Comes in horizontal and vertical flavors; the act of splitting a table over multiple files.
Bastard Programmer from Hell 
|
|
|
|
|
|
|
countmein wrote: My question is whether it is a candidate for partitioning it?
Yes, it is.
Bastard Programmer from Hell
|
|
|
|
|
|
Do you have an obvious partitioning column?
|
|
|
|
|
Thank you for your replies. Yes, I do have a column(primary key) that starts from 1 and automatically generated by adding 1.
|
|
|
|
|
That's not really the best partitioning column.
What you want is to partition the table so that queries is only fetching or inserting data to and from one partition at a time, if possible.
For example, If you want to partition a sales table, the date column would normally be a good choice. Most updates, inserts and queries would be done on the current year partition.
|
|
|
|
|
I want to use Backgroundworker, Progressbar and Linq
Please, can i get some reference
I've alread written Database backup using Linq.How can i user backgroundworker?
|
|
|
|
|
|
wow..this is a big list..kudos to you Pravin.. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
