Re: ADO performance

From: Arnie Mauer (someone_at_microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 10:28:17 -0400

"Guillermo Ortega A." <gortega@dcf.pemex.com> wrote in message
news:40e47ad1$1@newsgroups.borland.com...
>
> > Try setting BlockReadSize to 100 and CursorLocation to clUseServer.
> >
> > - Arnie
>
> No luck, the same performance.
>
> Guillermo
>
What OLEDB driver are you using for ADO?

We also noticed 'poor' performance when switching from the BDE to ADO. It
took some learning and tweaking the properties of the TADOQuery, but
eventually, performance was better than BDE/SQL Links.

- Arnie

Relevant Pages

  • Re: ADO performance
    ... "Guillermo Ortega A." ... For the queries in ADO i have set the properties as ... > The persistence framework get the results in a query and after it assigns ... > Query can be TQuery, ...
    (borland.public.delphi.database.ado)
  • Re: SQLServer/ODBC and nested subselects?
    ... > we run our test query against ADO instead of ODBC, ... Seems MS-SQL is rather poor when it comes to parameter handling ...
    (microsoft.public.sqlserver.odbc)
  • Re: What is the most efficient way to connect to a MySQL dbase?
    ... Yep, use ADO. ... I believe there is an OLEDB Driver available. ... > I am setting up a data driven site and I will be using MySQL. ...
    (microsoft.public.inetserver.asp.db)