The following connection options can enhance driver performance. You can also enhance performance through efficient application design. Refer to "Designing ODBC Applications for Performance Optimization" in the DataDirect Connect Series for ODBC Reference for details.

Array Size (ArraySize): If this connection string attribute is set appropriately, the driver can improve performance of your application by reducing the number of round trips on the network. For example, if your application normally retrieves 200 rows, it is more efficient for the driver to retrieve 200 rows at one time over the network than to retrieve 50 rows at a time during four round trips over the network.