David said:
Does anyone know if ADOX stored procedures are much faster than executing a regular query?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
- From the Access Help (AccXP):
"ActiveX Data Objects Extensions for Data Definition Language and
Security (ADOX) extends ADO to include objects for creating,
modifying, and deleting schema objects, such as tables and procedures.
It also includes security objects to maintain users and groups and to
grant and revoke permissions on objects."
So, in fact, you'd use ADO to run the SP and ADOX to create/modify the
SP.
If you're talking about an SP versus an Access query (JET SQL), it is
usually granted that a compiled & "planned" query object (SP or View)
will run faster than an Access query because the SP/view runs on a
faster/more memory computer (the server) and data doesn't have to be
transmitted across the network, as w/ an Access query.
- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQFeye4echKqOuFEgEQKgmQCg+kWXlYKLjFY9yJRpxgaQmyA+tgUAnjws
Ugr0JRz9JBuTd+lv1uiTm7RK
=euRu
-----END PGP SIGNATURE-----
--
