[thelist] ADO & ad_hoc SQL

Howard Cheng howcheng at ix.netcom.com
Mon Mar 11 13:22:01 CST 2002

You have to think of ADO as another layer. When you use the ADO add/update
method, the server has to convert that to a SQL statement and pass it to
the database server. Thus you writing out the explicit SQL statement
already saves that amount of processor effort.

At 11:49 AM 3/11/2002 -0700, kevin D. white wrote:
>AddNew is slower than writing out the SQL?  I was under the
>impression from my reading that avoiding ad_hoc SQL is generally a
>good idea under ADO.  Is it slower in this case because the code has
>to return a recordset just to do an update/insert?

Howard Cheng
howcheng at ix.netcom.com
AIM: bennyphoebe
ICQ: 47319315

More information about the thelist mailing list