Avoid Excessive Binds
The purpose of a SQLBindCol
or SQLBindParameter
call is to associate a type conversion and program buffer with a data column or parameter.
For a given SQL statement, if the type conversion or memory buffer for a
given data column or parameter is not going to change over repeated executions of the
statement, it is better not to make repeated calls to SQLBindCol
or
SQLBindParameter
. Simply prepare once and bind once to execute many
times.