Using Arrays of Parameters
- Last Updated: October 7, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Using Arrays of Parameters
When designing an application, using 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.
Because Sybase databases do not support parameter arrays natively, the Sybase Wire Protocol driver emulates them by sending T-SQL batches of Insert or Update statements to the database, which will improve performance.