Compare Data Access Models Performance

[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

 

[Alex Dybenko]

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

 

[solex]

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.