Re: BDE vs ADO

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

  • Next message: Noel: "Re: Protecting CDS files" 
    Date: Mon, 12 Jul 2004 12:18:33 +0100

    If you are doing "serious" database work - I wouldn't use Access at all - my
    personal opinion is that it is not too good in a multi-user environment and
    tends to corrupt easily. I've run mission critical stuff (millions of
    records) for years on MS SQL 7 2000 and never had a problem (so far!).

    I know MS SQL is pricey - but I think it is worth the money.

    HTH

    Barry
    "Rohit Dhamija" <rohit.dhamija@teleatlas.com> wrote in message
    news:40EE39C0.98A21F3B@teleatlas.com...
    > 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
    >

  • Next message: Noel: "Re: Protecting CDS files"

    Relevant Pages

    • Re: Diamond Access
      ... Use MS SQL 2000. ... Barry ... "Rohit Dhamija" wrote in message ...
      (borland.public.delphi.database.ado)
    • Re: Text not visible in OE
      ... Update your virus definitions and then run a full system scan. ... HTH - Please Reply to This Thread ... > that a fix was available and seemed to hold. ... Thanks, Barry. ...
      (microsoft.public.windowsxp.general)
    • Re: field alias when running SQL on sheet ranges
      ... E.TERM_TEXT AS FIELDALIAS ... > How would you do the same in range SQL? ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
      (microsoft.public.excel.programming)
    • Re: Deleting a Record.
      ... >> Have a look at www.mysql.com for sql syntax ... >> HTH, Jochen ... >> database editing interfaces. ... PHP DB Edit Toolkit -- PHP scripts for building ...
      (comp.lang.php)
    • RE: Opening a MS Access APP - if the SQL connection is not found.
      ... >> 'clean up the sql connection variables ... >> HTH, ... >> Phillip Williams ...
      (microsoft.public.dotnet.framework.aspnet)