[thelist] ADO & ad_hoc SQL (was: asp & adding db records)

kevin D. white kevin.white at bitshift.ws
Mon Mar 11 12:48:01 CST 2002


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I figured it out.  I needed to use adOpenKeyset for the Cursor Type.
Silly me.

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?

- ----- Original Message -----
From: <David at softv.net>
> You should consider sticking to the SQL method. The ADO AddNew
> method is actually slower...

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPIz8OVZZFo27GBIvEQIv6QCdEvLNPC3gbHsotcdYQlKGGy7juecAoOru
l05raEwwxJzLYCjMpPOpdEI0
=kiE7
-----END PGP SIGNATURE-----





More information about the thelist mailing list