[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