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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bad Performance when Data contains number with high precision

Patrick Kern6 days ago

Hi,

we Include="Oracle.ManagedDataAccess.Core" Version="23.7.0" to connect to an oracle ADB (23 AI) in OCI.

because we need data with precision, we set OracleConfiguration.SuppressGetDecimalInvalidCastException = true;

retrieving data via OracleDataAdapter.Fill (select * from) cause really bad performance. 2000 rows fetched in 3500ms.

when i use round(10) on each column, the performance is ok.

i think the logic of parsing to decimal is not effficient.

can you help me to sovle this problem?

is it possible to upload .zip archive?

thanks

Comments

Processing

Post Details

Added 6 days ago
5 comments
63 views