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 SAP ASE databases do not support parameter arrays natively, the SAP ASE Wire Protocol driver emulates them by sending T-SQL batches of Insert or Update statements to the database, which will improve performance.