11 The SQL Server Wire Protocol Driver : Using Arrays of Parameters

Using Arrays of Parameters
Microsoft SQL Server databases natively support parameter arrays, and the SQL Server Wire Protocol driver, in turn, supports them. When designing an application for performance, using native parameter arrays for bulk inserts or updates, for example, can improve performance. Refer to Chapter 5 “Designing ODBC Applications for Performance Optimization” in the DataDirect Connect Series for ODBC Reference for more information about using arrays of parameters to improve performance.