Skip to Main Content
Forums

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!

Error oracledatareader.reader(slow) application with ODT Oracle.data.access 2.112.3.0

user10089726Dec 5 2014 — edited Dec 9 2014

I am developing an application with ODAC for 11g r2 Oracle.data.access 2.112.3.0

I have a table(65000 records) containing the SDO_GEOMETRY column in a query and the recovery column byte type using

oracledatareader.reader but is very slow.

Example:

select SDO_UTIL.TO_WKBGEOMETRY(GEOM) as GEOM,OID from GEO.BGI_1001_URB_SARP_24878

oraComm.InitialLOBFetchSize = -1;

Oracle.DataAccess.Client.OracleDataReader oraReader = oraComm.ExecuteReader();

oraReader = oraComm.ExecuteReader(CommandBehavior.SequentialAccess);

while (oraReader.Read()){ //slow}   

I hope you can Help,

thanks,

Greetings.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2015
Added on Dec 5 2014
#odp-net
3 comments
1,294 views