Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZLA
Starting Member
6 Posts |
 Posted - 2007-12-21 : 13:41:19
|
| I know that connecttimeout and commandtimeout are separate entities. Is it possible to change the default command timeout value by changing the connection string? I need to increase the command timeout and want to know if I can do it without changing my code and rebuilding my ASP.NET 1.1 web app.Thanks in advance. -- ZLA |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
ZLA
Starting Member
6 Posts |
Posted - 2007-12-21 : 17:26:57
|
| Thank you. I'll have to modify the code rather than just modify the web config value. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-21 : 17:51:24
|
while you are modifying the code, you might as well put the timeout value in web.config and have your pages read it from there so you don't hit this again...
elsasoft.org |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-21 : 22:56:33
|
| While you are modifying code, check to see if your queries can be optimized. We've got one system that demands that queries take less than 2 seconds and we aren't talking about a small database. Increasing the command timeout is not an option for us but rather we've got to continuously keep up with performance tuning and optimizations.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Can you change command timeout via the connection?