Re: BDE vs ADO

From: barry clark (b.clark_at_clinmed.gla.ac.uk)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 17:13:07 +0100

Other nice features of ADO are:

1) Requery([]) - allows you to rapidly recover records while iterating
through another record set - gives a massive increase in speed as opposed to
constantly opening and closing queries to pick up the parameter changes.
2) All modern Windows environments (XP, 2000, 98) have support for ADO built
in - so nothing to deploy with your application. Makes life so easy when
compared with using BDE or ODBC. I'd never dream of going back!
3) You can can even faster performance using IP only networks. Set the ADO
connection network library to "dbmssocn" (in the build connection utility -
advanced). This forces it to use IP (instead of named pipes) and make
rolling out applications over an intranet both easier and run faster (no
need for Netbios or WINS etc) - although I'm assuming you are using
something like MS SQL in this case.

HTH

Barry
"Jeremy Collins" <jd.collins@ntlworld-not.com> wrote in message
news:40eba813$1@newsgroups.borland.com...
> Rohit Dhamija wrote:
>
> > ok, thanks, i had a tool having db connectivity in bde and i need to
evaluate
> > the performance of the tool by converting it to ado. Are there any
> > performance issuse with ADO ?
>
> Yes, definitely. Search the archives of this group (and
> borland.public.delphi.database.sqlservers) using Google Groups
> for "ADO performance" and you'll find a few tips, and
> links to articles on the Borland website.
>
> Once you are aware of the issues (for example don't use
> "TTable" type components against an SQL database), performance
> will be good.
>
>
> --
> jc
>
> Remove the -not from email

Relevant Pages

  • Re: C++ support for ADO
    ... We can connect to the database, open the record set and read field values. ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Connecting to external database provider
    ... and can get a connection to the server. ... method to open a record set, I do not get any records. ... there some settings in ADO that are preserved? ...
    (microsoft.public.access.gettingstarted)
  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)