-
The INSERTBUFF= option specifies
the number of rows to insert. SAS allows the maximum that is supported
by the DBMS. The optimal value for this option varies with factors
such as network type and available memory. You might need to experiment
with different values in order to determine the best value for your
site.
-
The READBUFF= option specifies
the number of rows to hold in memory. SAS allows the maximum number
that is supported by the DBMS. 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, then the rows that are returned
to the SAS application might be out of date. For example, if someone
else modifies the rows, you might not see the changes.
For more information
about the INSERTBUFF= and READBUFF= options, see
SAS/ACCESS for Relational Databases: Reference.