Prepared Execution

You can execute queries in one of two ways:

• Call SQLExecDirect with the SQL statement.
  
  
• Call SQLPrepare to prepare the query, and then call SQLExecute to execute the prepared query.

SQLExecDirect is a better choice if you execute the query only once. If you execute the query multiple times, however, (or if you run a parameter query multiple times), preparing it with SQLPrepare, and then executing it with SQLExecute, is considerably faster. Every time you execute a query with SQLExecDirect, Microsoft Jet parses the query, generates an execution plan, and then executes the query. When you use SQLPrepare, the query is parsed just once. Over the course of multiple queries, this can significantly enhance performance.