Contents Index Fetching rows through a cursor Fetching with scrollable cursors

ASA Programming Guide
  Using SQL in Applications
    Working with cursors

Fetching multiple rows


This section discusses how fetching multiple rows at a time can improve performance.

Multiple-row fetching should not be confused with prefetching rows, which is described in the next section. Multiple row fetching is performed by the application, while prefetching is transparent to the application, and provides a similar performance gain.

Multiple-row fetches 

Some interfaces provide methods for fetching more than one row at a time into the next several fields in an array. Generally, the fewer separate fetch operations you execute, the fewer individual requests the server must respond to, and the better the performance. A modified FETCH statement that retrieves multiple-rows is also sometimes called a wide fetch. Cursors that use multiple-row fetches are sometimes called block cursors or fat cursors.

Using multiple-row fetching 

Contents Index Fetching rows through a cursor Fetching with scrollable cursors