[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