Specifies the number of rows to buffer in memory before writing to your data source.
| Valid in: | LIBNAME statement that connects to an external data source |
|---|---|
| Category: | Bulk Loading |
| Default: | 10000 |
| Requirement: | When you specify this option, you must also specify BULKLOAD=YES. |
| Engine: | POSTGRES |
| Data source: | PostgreSQL |
| Note: | Support for this option was added in SAS 9.4M9. |
| See: | BL_WRITEBUFF= data set option, BULKLOAD= LIBNAME option |
Table of Contents
specifies the number of rows to hold 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.