TADO vs. TQuery

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


.

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)