Block cursor allocation by table: the -Dsrv PRGRS_TABLE_BLOCKSIZE,nnn option
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Block cursor allocation by table: the -Dsrv PRGRS_TABLE_BLOCKSIZE,nnn option
The -Dsrv PRGRS_TABLE_BLOCKSIZE,nnn option
where nnn is the size in bytes, indicates the
total allowable memory available to cursors of a given table. This
value puts a cap on the amount of memory all the open cursors against
a given table can consume. It does not determine an amount to be
allocated. This upper limit on memory allocation ensures that memory
is not overutilized.
ODBC_DEF_TABBLOCKSZ is the default value for
PRGRS_TABLE_BLOCKSIZE. It is currently set at 65,000 bytes. At this rate
approximately 18 tables open and utilizing all available cursor space for block cusrors would
utilize just 1 MB of memory. If record sizes are large or the typical row count of your result
sets is large and you have plenty of available memory and your open table count
is not too large, you might consider increasing this size. If you are using served OpenEdge
clients, keep in mind that the memory requirments of the DataServer server executable on the
server machine are compounded by the number of users attached to the database through the same
broker.