Re: Performance comparison: ADO, DAO, ODBC

From: Yuri Budilov <yuri.budilov_at_c031.aone.net.au>
Date: Sat, 20 Nov 1999 10:40:34 +1100
Message-ID: <skkZ3.5532$MZ.46603@ozemail.com.au>

dont forget that all MS work is concentrating on ADO and OLEDB so any performance deficiencies are likely to disappear in near future. Right now MDAC 2.1 SP2 is your best bet (released).

I would strongly recommend using ADO from VB5/6, using MS SQL Server 7.0 native provider (SQLOLEDB). I am told it also works well with Oracle7.3.4 and Oracle8 (MSDAORA provider, I think)

Yuri - always expressing personal opinions only

David Freiman <dfreiman_at_ix.netcom.com> wrote in message news:3821B783.52567A6B_at_ix.netcom.com...
> Forgive the cross-postings. I'd like opinions from all camps.
>
> Could you help me find out: if given a VB front end connecting to a SQL
> or Oracle backend, which is faster ADO, DAO or ODBC? My feeling is that
> ADO is the winner, since it is meant to supercede DAO, and ODBC is
> generally a slow connection in my experience. I need to know which would
>
> give the best performance.
>
> What criteria do I need to consider to refine my question and make a
> decision?
>
> --
> David Freiman
> dfreiman_at_ix.netcom.com
>
> "No opera plot can be sensible, for people do not sing when they are
> feeling sensible." W. H. AUDEN
>
Received on Fri Nov 19 1999 - 17:40:34 CST