Array binding

Client-Library’s array binding allows an application to bind a result column to an array of program variables. Multiple rows’ worth of column values are then fetched with a single call to ct_fetch.

Array binding can increase application performance, especially when result sets are large (more than 20 rows) and contain only a few small columns (total row size of less than 512 bytes).

Array sizes of 4 to 16 are most effective; larger array sizes do not increase throughput significantly.

DB-Library applications that use row buffering can often use Client-Library array binding instead.

For more information on Client-Library’s array binding, see “Client-Library’s array binding”.