Connection timeout setting and query performance

Connection timeout setting and query performance

Postby JORGEMAL » Mon 01 Jul 2013 21:58

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?
JORGEMAL
 
Posts: 165
Joined: Thu 03 Jul 2008 23:55

Re: Connection timeout setting and query performance

Postby Pinturiccio » Wed 03 Jul 2013 13:11

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.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL