Record Buffer Size (-Mr)
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
Record Buffer Size (-Mr)
Use Record Buffer Size (-Mr) to improve
performance by varying the standard record buffer size.
| Operating system and syntax | UNIX / Windows |
-Mr
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Session | 32,000 | 96 | — | 1,012 |
- n
- The standard record buffer size in bytes. The default value of 1,012 bytes is appropriate in nearly all cases.
On some systems, you can use Record Buffer Size (-Mr) to improve performance by varying the standard record buffer size. However,
the default value of 1,012 bytes is appropriate in nearly all cases.
This parameter determines the maximum size of a record buffer the ABL client can hold in its buffer cache. If you need to fetch a row that is larger than this value, then the AVM allocates a new record buffer to hold the larger record and frees the buffer after the record buffer goes out of scope. If you set this parameter too low, the client will spend more time allocating and freeing memory. Set this parameter to be larger than the average size record the application will read from the database.