Hi everyone
When I test the latest version of the ODP components(Oracle.ManagedDataAccess.Dll Version:12.1.0.2.160119) and found a Performance problem
use Test code e.g:
void TestPerformance()
{
string connStr = @"Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =IP)(PORT =1521)))
(CONNECT_DATA =(SERVICE_NAME = *)));user id=*;password=*;Pooling =true;Max Pool Size=100;Min Pool Size=1;"
OracleConnection oraConn = new OracleConnection(connStr);
try
{
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();
oraConn.Open();
watch.Stop();
SetInfo("Spend Time" + watch.ElapsedMilliseconds + "ms");
}
finally
{
if (oraConn != null)
{
oraConn.Close();
oraConn.Dispose();@
}
}
}
With the use of the ODP.DLL(Oracle.DataAccess.Dll Version:2.111.7.0) contrast test results
ODP Version | First | Second | Third |
---|
ManagedDataAccess | 682ms | 1ms | 0ms |
DataAccess | 78ms | 1ms | 0ms |
Although the time is not much, but our application can access different database during initialization, accumulated a lot of time
Look forward to your reply