Connection timeout setting and query performance

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
JORGEMAL
Posts: 171
Joined: Thu 03 Jul 2008 23:55

Connection timeout setting and query performance

Post by 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?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Connection timeout setting and query performance

Post by 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.

Post Reply