Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : ODBC options : Using the block cursor switches : Adjusting values
 
Adjusting values
With the default size, approximately 6.5 open cursors and result sets per table can be established at a given time before the maximum block memory area (PRGRS_TABLE_BLOCKSIZE) is exceeded. At 10,000 bytes, 104 new block allocations can be established before the maximum block memory (PRGRS_MAX_MBLOCKSIZE) is exceeded. If record sizes are large or the typical row counts for your results sets are large, you can consider increasing one or both of these sizes. Conversely, if record sizes are small or the typical row counts for your results are small, you can consider decreasing theses sizes. Consider setting these tuning parameters based on your typical requirements and then override them for specific queries that are the exceptions using the query tuning option.