[AccessD] Queries vs In-line SQL

Charlotte Foust cfoust at infostatsystems.com
Wed Jun 1 10:10:16 CDT 2005


In 2000 and later, saved queries are optimized and so should execute
faster than on the fly queries, including the sort generated in code.

Charlotte Foust


-----Original Message-----
From: Joe Rojas [mailto:JRojas at tnco-inc.com] 
Sent: Wednesday, June 01, 2005 6:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Queries vs In-line SQL


Is there a performance increase between in-line SQL and queries in
Access 2000?

For example:

Going from
CurrentDB.Execute "SELECT * FROM MyTable"

To putting the SELECT statement above in a query?

Thanks!
JR





This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please
notify the sender as soon as possible and destroy this message. While
TNCO, Inc. uses virus protection, the recipient should check this email
and any attachments for the presence of viruses. TNCO, Inc. accepts no
liability for any damage caused by any virus transmitted by this email.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list