What does OCIPrefetchRows do?

OCIPrefetchMemory and OCIPrefetchRows control parameters relating to the Oracle OCI's prefetching facility. However, use of this facility has been disabled in the OpenLink agent and Lite driver because of problems experienced with Oracle 8.x and indicator variables.

To minimize server round trips and maximize performance, the OCI can prefetch rows when executing a query. This prefetching operates independently of OpenLink's prefetching facillty. OCI prefetching can be customized by setting two attributes; OCI_ ATTR_ PREFETCH_ ROWS and OCI_ ATTR_ PREFETCH_ MEMORY. The OCIPrefetchMemory and OCIPrefetchRows settings in the OpenLink setup dialogs map directly to these, two OCI attributes.

OCIPrefetchMemory sets the memory allocated for rows to be prefetched. The application then fetches as many rows as will fit into that much memory.

OCIPrefetchRows sets the number of rows to be prefetched.

When both of these attributes are set, the OCI prefetches rows up to the OCIPrefetchRows limit or until the OCIPrefetchMemory limit is reached, if this is lower.