Time Consuming with large scale data by using OracleDataAdapter.Fill

[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

 

[Uri Dor]

sounds like a server-side performance issue - did you try checking the
number of I/O operations, the query plan, stuff like that?

 

[A Little Cat]

Dear Uri Dor,

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

Thanks for your kindly information.