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 number of rows retrieved is limited only by the amount of memory installed on the querying computer.

The Oracle Adapter default for the number of rows to be retrieved per fetch is based upon an allocation of 64K buffer. A calculation is then performed to indicate the number of rows that can be held in the buffer.