The performance of dotConnect for Oracle and Oracle SQL Developer differs. Try creating a simple console application that would execute only your query. How long does it take to execute the query? Is it 30 seconds or less than a second?
PatrikAhlquist wrote:It's always a small value between Prepare and Execute
Command execution time displayed is not always the actual one. Try executing the following code:
Code: Select all
OracleMonitor mon = new OracleMonitor() { IsActive = true };
OracleConnection conn = new OracleConnection("your connection string");
conn.Open();
OracleCommand comm = new OracleCommand("BEGIN DBMS_LOCK.sleep(20); end;", conn);
comm.ExecuteNonQuery();
conn.Close();
It takes our dbMonitor approximately 20 seconds to process this command.