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