Devart Forums

What are the performance benefits of using connection pooling (in terms of time to actually set up a connection), and what are the differences between devart connection pooling and oci connection pooling? Are there situations where you should one or the other, or disable pooling completely?

Provided that the connection was once opened and placed to the pool, it can be reopened much faster. For details, please see the MSDN documentation:
http://msdn.microsoft.com/en-us/library/bb399543.aspx
http://msdn.microsoft.com/en-us/library/ms254502.aspx

The OCI pool is controlled by the Oracle client and is used for OCI connections. dotConnect for Oracle provides its own connection pool which is used for Direct connections.

If connection pooling is enabled, the connection is not actually closed when you call the Close() method in your application. If you need to have full control on your connections, you may be interested in disabling the pooling feature.

What's a reason of using Devart connection pooling where there is a native one?

For direct mode only?

The connection pooling feature was implemented for the Direct mode. In the OCI mode, you may use either our or native pooling without considerable differences in performance.