Ado net command time out in property in sqlcommand?

Question

In webapplication, I put

sqlcommand.CommandTimeout=0;

Is this statement is recommended or not [good progamming style], or which one is good if it is not good?

If you're ready to wait forever ...

marc_s
– marc_s

2011-10-13 08:52:24 +00:00
Commented Oct 13, 2011 at 8:52 — marc_s
– marc_s, Commented Oct 13, 2011 at 8:52

Richard · Accepted Answer · 2011-10-13 08:34:45Z

2

From the SqlCommand.CommandTimeout documentation:

A value of 0 indications no limit, and should be avoided

It could cause the request and the thread processes it to hang indefinitely. This is a waste of resources if nothing else.

It would also make it harder to identify if you have commands that are not completing in a reasonable time.

is this statement is recommended or no

Not.

answered Oct 13, 2011 at 8:34

Richard

110k21 gold badges214 silver badges279 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Filburt Over a year ago

+1 Overriding the command timeout is somewhat of the last resort - if the problem can already be tracked down to a single command it should be possible to find a better solution.

Collectives™ on Stack Overflow

Ado net command time out in property in sqlcommand?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related