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 w开发者_运维技巧ith Java and the IBM jdbc driver, it is a lot faster.

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

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.