This option improves
performance by specifying a number of rows that can be held in memory
for input into SAS. Buffering data reads can decrease network activities
and increase performance. However, because SAS stores the rows in
memory, higher values for READBUFF= use more memory. In addition,
if too many rows are selected at once, the rows that are returned
to the SAS application might be out of date.
When READBUFF=1, only
one row is retrieved at a time. The higher the value for READBUFF=,
the more rows the
SAS/ACCESS engine retrieves in one fetch operation.
- DB2 under UNIX and PC Hosts:
-
By default, the SQLFetch
API call is used and no internal SAS buffering is performed. Setting
READBUFF=1 or greater causes the SQLExtendedFetch API call to be used.
- Greenplum, Microsoft SQL Server, Netezza, ODBC, Sybase IQ:
-
By default, the SQLFetch
API call is used and no internal SAS buffering is performed. Setting
READBUFF=1 or greater causes the SQLExtendedFetch API call to be used.