Row count (-ROWCNT)

Use the Row Count adapter command (-ROWCNT) to specify the number of rows to be retrieved per fetch.

-ROWCNT row_count

Option

Description

row_count

The number of rows to be retrieved per fetch. The time to fetch is optimized in accordance with the increase in the number of rows to retrieve. Therefore, a significant performance improvement may be gained by retrieving as many rows as possible in a single fetch.

The factor limiting the number of rows that can be retrieved is the memory requirement because the return buffer must be large enough to hold the rows retrieved.

The default for the number of rows to be retrieved per fetch for the Informix Adapter is one row.