Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : ODBC options : Using the block cursor switches : Block cursor allocation by table: the -Dsrv PRGRS_TABLE_BLOCKSIZE,nnn option
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.