Insertion, Deletion, and Update Performance

Several options are available for performing insertions, deletions, and updates. To perform these operations, you can execute an SQL statement or call SQLSetPos. If you perform them with an SQL statement, you can call SQLExecDirect, or prepare the statement and call SQLExecute. You can include multiple statements in a transaction. This section describes the relative performance of these methods.