Specifies the number of rows to buffer in memory before writing to your data source.
| Valid in: | DATA and PROC steps (when accessing data that is in an external data source) |
|---|---|
| Category: | Bulk Loading |
| Default: | LIBNAME option value |
| Requirement: | To use this option, you must also set BULKLOAD=YES. |
| Data source: | PostgreSQL |
| Note: | Support for this option was added in SAS 9.4M9. |
| See: | BL_WRITEBUFF= LIBNAME option, BULKLOAD= data set option |
Table of Contents
specifies the number of rows to buffer in memory before writing to your data source.
Use this option to improve performance for bulk loading to your data source. SAS/ACCESS adjusts this value automatically based on row size. Specifically, the number of rows * row size must not exceed 500MB for data sources that run on Linux. The number of rows * row size must not exceed 128MB for data sources that run on Windows.