Maximum memory for a static cursor
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The SYNSEL_CURSORMEM environment variable sets the maximum memory size for a static cursor.
Value
The maximum size of a static cursor, in kilobytes by default or followed by B, K, M, or G to specify the units in bytes, kilobytes, megabytes, or gigabytes, respectively.
Discussion
For xfServer, SYNSEL_CURSORMEM should be set on the client side. The value specified on the client may not be the exact value used on the server for the following reasons:
-
When using a file-backed static cursor, the maximum size must be an even multiple of the memory granularity (for example, the page file size) and will be adjusted if it isn't.
-
When using a file-backed static cursor, the size will only be expanded in blocks of 20 MB at a time. If the specified maximum isn't a multiple of 20 MB, the effective maximum will be the largest multiple of 20 MB less than the specified maximum.
-
On OpenVMS, to avoid running out of memory, the maximum size will be reduced if necessary until two static cursors of the specified size would take up less than 75 percent of the total paging file quota for the process.
-
The value limits the amount of memory that a static cursor itself will use but doesn't necessarily limit the total amount of memory that will be allocated to use a static cursor. On OpenVMS in particular, large queries may temporarily allocate up to twice the maximum size if the query is big enough.
If SYNSEL_CURSORMEM is not set, the effective value is 256 MB on OpenVMS and 32-bit systems or 8 GB on 64-bit systems (server-side in the case of xfServer), but these values may be subject to change.
Setting location
The environment.
Used by
The Synergex.SynergyDE.Select.Select class.
Examples
On Windows, if set at the command prompt,
set SYNSEL_CURSORMEM=4G
