Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DataTable.Load slow on 11g

hx00Nov 15 2016 — edited Nov 15 2016

When I execute the following code:

IDbCommand command = session.Connection.CreateCommand();

command.CommandText = sql;

IDataReader reader = command.ExecuteReader();

result.BeginLoadData();

result.Load(reader);

result.EndLoadData();

reader.Close();

It takes 2secs on 10g(14000 records),but 20secs on 11g(16000 records),

with the following code , Almost the same times

OracleDataAdapter ada = new OracleDataAdapter(command as OracleCommand);

ada.Fill(result);

This is a bug?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2016
Added on Nov 15 2016
0 comments
488 views