CODEWITHSUNDEEP
c#.netdatabasedb2database-connection
Hotspur
Hotspur

Reputation: 53

Slow DB2 connection on .NET

I'm working on a project where we're gonna fetch data from a DB2 database. I've been testing with both the ibm provider and simple odbc and with both approaches the connection open method is very very slow.

If I try doing the same thing with Java and the IBM jdbc driver, it is a lot faster.

Does anyone have any tips on how to improve performance in .NET ?

Upvotes: 2

Views: 1808

Answers (1)

PerformanceDBA
PerformanceDBA

Reputation: 33818

Faster, slower, they are all relative terms, relative to what you know.

  1. Read this for background:

    Does sybase 15 support the bcp api in java?

  2. Fine, JDBC is faster than ODBC, because IBM did a good job of implementing it. Sure, you can check the configuration of your ODBC vs your JDBC, and improve it a little.

  3. Both JDBC and ODBC are excruciatingly slow compared to using IBM CLient Library. Get your hands on that, it is free.

Upvotes: 3

Related Questions