Re: BDE vs ADO

From: Rohit Dhamija (rohit.dhamija_at_teleatlas.com)
Date: 07/09/04 

Date: Fri, 09 Jul 2004 11:52:56 +0530

Thank a lot, Currently we are using MS Office -XP , access database.
and Delphi 5.
How is Diamond Access connectivity as compared to ADO ?
Please comment.
Regards,
Rohit

barry clark wrote:

> 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)
  • Re: Problem with Recordset Find method
    ... In ADO 2.5 ... > key in your database because in that case the field will be automatically ... > works for you or not.If the problem persists then probably there's something ... >> I tried to create an index on the field in the record set. ...
    (microsoft.public.vb.database.ado)
  • ADO faster than ADO.net ?
    ... I would like to know why I can use ADO (ADODB record set) running in vb.net ... to insert records into an MS Access database 5-6 times faster than I can ... I have a small vb.net project that inserts 30,000 records into a database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access performace help
    ... I move the data file to the network folder, ... Should I remove the linked tables and use DAO / ADO? ... how do I assign the record set created with ADO to the ...
    (microsoft.public.access.formscoding)
  • Re: Access performace help
    ... First thing to do is check the Access Performance FAQ Tony Toews has at ... Should I remove the linked tables and use DAO / ADO? ... how do I assign the record set created with ADO to the ...
    (microsoft.public.access.formscoding)