Enhancing ADO Performance

From: Dave (dave_at_powerworld.com)
Date: 06/23/04

  • Next message: Nik Alleyne: "Re: Sorting the Grid" 
    Date: Wed, 23 Jun 2004 13:33:56 -0500

    We are currently exploring the retrieval of data for our software from
    database sources by composing some small test applications (D7 Pro). We
    currently have applications constructed to retrieve data from ODBC
    tables using the native BDE connection and using the ADO connection. We
    worked with both because of the installation issues when using the BDE
    approach, such as the bundled BDE dll and potential registry access for
    BDE purposes during the application installation. It seems that ADO
    would avoid many of these BDE installation issues, but also seems to be
    somewhat slower in its data retrieval than the BDE application we've
    written to retrieve the same data from the same source.

    Does anybody have any suggestions on how to improve the performance of the
    ADO connection?

    Thanks
    Dave Savageau

  • Next message: Nik Alleyne: "Re: Sorting the Grid"

    Relevant Pages

    • Re: Enhancing ADO Performance
      ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
      (borland.public.delphi.database.ado)
    • Re: Enhancing ADO Performance
      ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... The execution plan is also saved. ...
      (borland.public.delphi.database.ado)
    • PLEASE HELP!!! Retrieving Data
      ... I am trying to learn Delphi 6. ... I am an experienced VB programmer. ... have googled and searched and tried to find help in using the BDE ... and I just need to know how to retrieve one freakin' record. ...
      (comp.lang.pascal.borland)
    • Re: PLEASE HELP!!! Retrieving Data
      ... PcolaBob a écrit: ... have googled and searched and tried to find help in using the BDE ... and I just need to know how to retrieve one freakin' record. ... It seems like every single explanation throws the data in a ...
      (comp.lang.pascal.borland)