Query perfomance

[Nikos Antoniou]

Hello,

I would like to ask if the Queries in Access have a perfomance advantage
over query strings (executed via ADO) that perform exactly the same task. In
SQL Server, a stored procedure is a precompiled set of SQL statements, with
an optimized execution plan, therefore is executed faster. Does the same
happen with Query objects in Access?

Thanks in advance for any feedback,

Nikos Antoniou

 

[chas]

Hi Nikos,

Indeed, the same can be said of Access/JET queries as
Stored Procedures in SQL Server, a saved query is
optimized for efficiency. SQL strings have to be parsed
on the fly.

As an aside, if you use a SQL string in a Forms
RecordSource or a List/ComboBox Rowsource in Access 2000
or above, the SQL string is saved as a hidden query and is
thus more efficient.

hth

chas