Using arrays of parameters
- Last Updated: November 2, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Microsoft SQL Server 8.0
- Documentation
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 Designing ODBC applications for performance optimization in the Progress DataDirect for ODBC Drivers Reference for details.