Re: Prepared TADOQuery Question


Is there any point in using parameterized prepared queries in ADO? Or am
I
using the TADOQuery incorrectly?

SQL server converts queries to stored procedures and then caches the
stored
procedure for future use. This is one way it executes more efficiently..
Using parameterized queries in Delphi should speed up the conversion but
using
Prepare in Delphi doesn't help


Thanks.


.

Relevant Pages

  • Re: Access migration to SQL Server
    ... caveat in the first sentence, i.e. remove access all together and you don't ... > about having to convert all your queries to views and stored procedures. ... > using a named query parameter to look up a value from a form control and ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... caveat in the first sentence, i.e. remove access all together and you don't ... > about having to convert all your queries to views and stored procedures. ... > using a named query parameter to look up a value from a form control and ...
    (microsoft.public.sqlserver.server)
  • Re: Off Topic - Access to Postgres
    ... >>However, I find that using views, stored procedures and pass through queries ... >procedures and pass-through queries. ... >The reason pass-through queries are a problem for Access (and stored ... - To the extent that your application relies on server-side objects, ...
    (comp.databases.ms-access)
  • Re: Off Topic - Access to Postgres
    ... If sprocs and pass through queries are not the solution then ... >However, I find that using views, stored procedures and pass through queries ... The reason pass-through queries are a problem for Access (and stored ... may have to create a saved pass-through query, ...
    (comp.databases.ms-access)
  • Re: queries Vs Stored Procs
    ... > queries in one stored procedure rule. ... > should put each branch into its own stored procedures. ... to have a chain of Procs rather than a chain of queries. ... a single procedure can execute and use the results from several ...
    (microsoft.public.sqlserver.programming)