C # million data query timeout problem

When filtering some information from millions of data in C #, there are often errors in program connection timeouts, many common errors, such as timeout expired. The timeout period elapsed prior to completion of the operation or the server and so on

This article describes several common solutions, purely personal opinion, welcome to shoot Bricks

①: Of course, the first step to check whether connection did not close the problem, the general novice will make this mistake, need to look carefully oh, this is not detailed said.

②: If you copy the SQL statement to Query Analyzer, and if the execution time is longer than 30 seconds, the following solution is generally used:

First analyze the cause of timeout, generally connection not closed or sqlconnection.connectiontimeout timeout, the other is sqlcommand.commandtimeout caused by, This method of SqlCommand is to get or set the wait time before terminating an attempt to execute a command and generating an error.

His default is 30 seconds, you can set to 0, it means no limit, but it is best not to set 0, otherwise it will wait indefinitely, only to the time of the Query Analyzer, to set this time can be

③: The execution time is not very long, but still the operation timeout, then there are many reasons, usually there are two kinds of, ASP. NET application has timed out, or the connection lifetime of the connection pool has passed, because the connection pool default value is 60 seconds, the two solutions are:

To resolve the application request timeout:

Add the following statement in Web. config:

<system.web>

</system.web>

Executiontimeout: Is the maximum time limit allowed to execute a request, in seconds
maxRequestLength: Indicates the maximum file upload size supported by ASP. This limitation can prevent .... We all know that. Oh

Resolve the problem with the program pool life cycle:

Modify in the database connection string: DATABASE=AA;UID=SA;PWD=SA; Pooling=true; MAX Pool size=1024; Min Pool size=1; Connection lifetime=60

As for the meaning basically from the English meaning of everyone will understand, hehe ... Of course, min Pool size=1 This setting has a lot of attention, if you want to study can look at the following article, hehe

Http://www.cnblogs.com/ZHUYIN/archive/2011/11/02/2232578.html

C # million data query timeout problem