Re: Fastest record create method with JET 4.0


Stephen Howe wrote:
As someone else pointed out, DAO code may be written shoddy and still
do the job. Even with lazy code, DAO ought to be faster at inserting
records into an Access database than ADO, even though Microsoft says
otherwise.

Where do they say that?

It is in at least a dozen KnowledgeBase articles on the MSDN CDs. Since
Microsoft has updated their JET engine at least twice since then,
perhaps they no longer give such advice.

I believe Microsoft do acknowledge DAO is faster than ADO for Access
databases
See http://support.microsoft.com/kb/225048/
where you can read what DAO and ADO philosophy.

But frequently programmers use ADO badly so the performance difference may
not be that apprecaibly different.

Stephen Howe

.

Relevant Pages

  • ADO connection Open failure
    ... At some point in the code I'm using ADO to export an Access dataset. ... Access database on the shared drive; ... The Excel file is using the following references: ... Microsoft Office 11.0 Object Library ...
    (microsoft.public.excel.programming)
  • Re: CHANGING from DAO to RDO
    ... For a long while, Microsoft was heavily promoting ADO, but in recent times, ... I don't know _where_ you got the idea that ADO and RDO were the only methods ... DAO and, for them too, DAO was simpler and easier. ... 70 MB is not an exceptionally large Access database -- you have 1930 MB more ...
    (microsoft.public.access.modulesdaovba)
  • Re: Fastest record create method with JET 4.0
    ... records into an Access database than ADO, ... I believe Microsoft do acknowledge DAO is faster than ADO for Access ...
    (microsoft.public.data.ado)
  • Re: Fastest record create method with JET 4.0
    ... records into an Access database than ADO, ... I believe Microsoft do acknowledge DAO is faster than ADO for Access ...
    (microsoft.public.data.ado)
  • Re: Recommended data access model
    ... This is from MDAC 2.8 SDK. ... "The Role of ADO in MDAC ... The Microsoft Data Access Components provide data access that is ... easy-to-use interface to OLE DB. ...
    (comp.databases.ms-access)