ValidateConnection property in the connection string
641000May 23 2008 — edited May 23 2008Hi!
In my application, for every single call which I need to make, I obtain a connection from the ODP.NET pool (i.e., i create a new OracleConnection() and call Open on it), and after my operation is over, I release the connection back to the pool (calling connection.close) (NOTE - the pooling property is true).
I see that there is a ValidateConnection property which ensures that the connection in the pool is valid before obtaining it.
Now, in my application, I open thousands of connections, and close them (serially). I was wondering whether there would be any performance hit if I set ValidateConnection to true. How does ODP.NET validate the connection? Does it do any expensive processing?
Thanks.