My problem is that my application in C# is extremely slow.
It search a single compagny number with parameters.
When i take the request in SQLdeveloper i had the result in 0.015 second
The same request with this code takes ~800 seconds:
using (var connection = new OracleConnection(MyConnectionString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = getCompanyNumberSQL;
command.Parameters.Add(":identifierName", OracleDbType.NVarchar2, identifierName, ParameterDirection.Input);
command.Parameters.Add(":identifierValue", OracleDbType.NVarchar2, identifierValue, ParameterDirection.Input);
command.Prepare();
var r = command.ExecuteScalar(); //~800seconds
result = r == null ? string.Empty : Convert.ToString(r);
connection.Close();
}