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!

Bad Performance when Data contains number with high precision

Patrick KernApr 1 2025

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

This post has been answered by Alex Keh-Oracle on May 29 2025
Jump to Answer
Comments
Post Details
Added on Apr 1 2025
10 comments
352 views