Command timeouts with SqlHelper (Data Access App. Blocks)

[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.

 

[William Ryan eMVP]

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.