Command timeouts with SqlHelper (Data Access App. Blocks)

  • Thread starter Thread starter Tim Thornton
  • Start date Start date
T

Tim Thornton

Is there a way to modify the CommandTimeout when using the Data Access
Application Blocks SqlHelper functions?

Some commands that I try to execute using SqlHelper never get a chance to
complete.
 
You can change the commandtimeout property of your command object if you
need to, but be careful b/c most of the time the problem isn't really the
commandtimeout but your query. First make sure you can't speed up the query
(use the Index Tuning wizard and check out the execution path, use profiler
etc) to make sure your query isn't a dog first.
 
Back
Top