Re: TADO vs. TQuery

"Allan Nielsen" <ace-allanREMOVEME@xxxxxxxxxxxxxx> wrote in message
news:42b7ab33@xxxxxxxxxxxxxxxxxxxxxxxxx
> How much faster is ADO typically over a simple TQuery using odbc?
> I have an application that uses ODBC to connect to MS SQL Server 2K. Will
> this benefit greatly if I changed to ADO?
>
> Thank you.
>
> Allan
>

I guess most of the guys here will claim that BDE is pretty fast, but I have
no complaints about ADO. But I would not consider speed the dealbreaker
here. Go for ADO, you will not regret it. Ease of use, ease of
configuration, capabilities etc. Besides that, using ADO, you can still use
ODBC (allthough I would not recommend that)

Maurice


.

Relevant Pages

  • Re: Connection from ASP- ODBC vs. SQLOLEDB
    ... The ASP code is already using ADO (adodb.connection, ... The new provider is better than ODBC isn't it, ... SQL Server Client Network Utility- "Enable Shared Memory": ... ASP, ASP.NET as well as Microsoft Content Management Server 2002 SP1a. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: Heres a rather broad question...
    ... ADO.NET and not its predecessor, will they fix any ADO problems that arise? ... authentication or permission issues with SQL Server 2000. ... The only thing I would say is that Microsoft have frozen development on ODBC ...
    (microsoft.public.data.ado)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... My fix was to use ADO ... With ODBC the connection remains open the ...
    (comp.databases.ms-access)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... against the sql server (ADO was specifically designed for use with sql ... the connection is closed. ...
    (comp.databases.ms-access)