Connection timeout setting and query performance
Connection timeout setting and query performance
Our appliction performs several very long processes to our database and everything was running just fine until a connection timeout issue appeared. Our application records the initial and final times and also shows the total time that the process takes. Because of the connection timeout issue I set the connection timeout to zero and I have noticed that the processes take significantly less time now. Is this a normal behavior?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connection timeout setting and query performance
If the connection timeout parameter value is not equal to zero, a separate thread is created for establishing a database connection. In case the connection timeout parameter value is equal to zero, an additional thread is not created. This might be the reason of performance increase you observe.