Time Consuming with large scale data by using OracleDataAdapter.Fill

  • Thread starter Thread starter A Little Cat
  • Start date Start date
A

A Little Cat

Dear,

I'm using Microsoft .NET Provider for Oralce, but it's time consuming
on large scale record by using OracleDataAdapter.

Code Snippet: -
DataSet dataset = new DataSet();
OracleConnection conn = new OracleConnection();
OracleCommand myCommand = new OracleCommand();
OracleDataAdapter adapter = new OracleDataAdapter();

conn.ConnectionString = dbConnectionString;
myCommand.Connection = conn;
conn.Open();
myCommand.ExecuteNonQuery();

adapter.SelectCommand = new OracleCommand(query, conn);
adapter.Fill(dataset);
conn.Close();


During traced the program on "adapter.Fill(dataset);", it needs 10 mins
for 35,152 records. But the execution time on sql*plus is around 23
secs for the same query. Is it any mistakes on the program or any
suggestion for this.

Thanks for your kindly attention.

Note: use with VS2003, .NET FW 1.1, Oracle9i
 
sounds like a server-side performance issue - did you try checking the
number of I/O operations, the query plan, stuff like that?
 
Dear Uri Dor,

How can I check for the number of I/O operations or query plan??

Thanks for your kindly information.
 
Back
Top