Compare Data Access Models Performance

  • Thread starter Thread starter Malee
  • Start date Start date
M

Malee

To compare performance between

- ADO with provider for specific database
- ADO with ODBC provider
- ODBC Direct thru DAO

Which is the best one ? And have any disadvantage ?

Any suggestion would be much appreciated,
Malee
 
i think in Access developers handbook it was a test of these 3, dont remeber
exact result, but remeber that it was not a big difference. Anyway - i think
first should be better, as it uses less layers
 
If you are using Access as your database then DAO(without ODBC) is the
fastest in my experience. ADO is faster then ODBC when it comes to
accessing SQL server.
 
Back
Top