Kbase 11475: How we calcualate WORKFILE space in versions 6 and 7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How we calcualate WORKFILE space in versions 6 and 7
Beginning with the later versions of version 6 (6.2K) for example (but
perhaps before, workfile records have been allocated in 32-byte
chunks instead of 64-byte chunks as documented under DEFINE WORKFILE
in the Language Reference manual.
Each workfile record requires 60 bytes of overhead. Each workfile
field requires 2 bytes of overhead + the actual data length. The sum
of the field-level requirements * number of records plus the workfile
overhead of 60 bytes is then rounded to next even multiple of 32-bytes
since that's how workfile space is allocated.
The rounded total can then be converted to number of Kb for the
value of the local buffer startup parameter (note that this is the
size required for only the workfile -- actual local buffer size will
need to be higher to include other variable and record requirements.)
For version 7 workfiles, add 10% more memory to the calculation
above to allow for a few new fields in common structures.
See also: Language Reference DEFINE WORKFILE
System Admin II Startup Options Local Buffer Size
Progress Software Technical Support Note # 11475