DevOps, CI/CD and Automation

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!

Slow ODBC-Connection to C#.NET program

627888Mar 11 2008 — edited May 9 2012

Hi,

I just started working with Oracle and already have a problem:

I wrote a C#-form which includes a DataGrid, where I want to display a table from Oracle 10g. It has about 40.000 lines and 20 columns (just simple numbers and strings).

I tried to fill this datagrid, connecting with "Microsoft ODBC for Oracle", but filling takes more than ONE minute. Client and Server have nearly no CPU activity and network traffic of about 500kbit/sec.

Displaying the same table in Oracle SQL-Developer, it takes just 2 seconds with about 15Mbit/sec.

Anyone got an idea what the problem is?
I already tried the Oracle ODBC-driver but this one is very slow too. Is ODBC the problem?
How does SQL-Developer work?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2012

Added on Mar 11 2008

#odbc, #windows-and-net

6 comments

7,404 views