OleDbDataAdapter, OdbcDataAdapter, OracleDataAdapter, SqlDataAdapter

[Randy]

I've heard that ODBC is inheritantly slow. Are the other adapters faster
than the ODBC one when moving large chunks of data? Or do they all use the
same underlying mechanism to transfer data?
Essentially, I'm trying to find out which one is the fastest...

Thanks

 

[Dino Chiesa [Microsoft]]

In general, the more recent implementations are faster.
OleDb is faster than ODBC
the Managed Providers (for Oracle, SQL, DB2 and others) are faster than
OleDB.

BUT,
this is not a hard rule. Different scenarios behave differently.
You have to test to find out.

 

[Guest]

All it depends upon the datasource.For e.g If u r using Sql Server 7.0 or
above, use the Sql Server Data Adapter, as they are using the TDS . If you
are only access DataBase, still ODBC is faster and that's y microsoft has
came up with ODBC data provider along with OleDbDataProvider.

regards
Nishith