Parameters are Quicker
10-Jul-94 03:37:29
Sb: #30222-Parameters are Quicker
Fm: Ronald Laeremans 100142,747
To: Chris Bluethman 72347,3306
Chris,
Requery DOES NOT work when you change the filter or sort clauses, this is
stated wrong in the docs. It will only work with parametrised recordsets.
So what happens is that close/open, does a new SQLPrepare and then a SQLExecute
while Requery only does the SQLExecute. This may be much more efficient in
theory, but e.g. with SQL Server NT and simple queries, there is not that much
to gain. With complicated queries there is a significant advantage in
eliminating the prepare however.
-Ronald-