HASHSPIL parameter: Difference between revisions
Jump to navigation
Jump to search
Automatically generated page update |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Template:HASHSPIL parameter subtitle}} | {{Template:HASHSPIL parameter subtitle}} | ||
==Summary== | ==Summary== | ||
<dl> | <dl> | ||
<dt>Default value | <dt>Default value | ||
<dd> | <dd> 16 | ||
<dt>Parameter type | <dt>Parameter type | ||
<dd>System | <dd>System | ||
| Line 11: | Line 9: | ||
<dd>User 0 parameter line | <dd>User 0 parameter line | ||
<dt>Related products | <dt>Related products | ||
<dd>All | <dd>All | ||
<dt>Introduced | <dt>Introduced | ||
<dd><var class="product">Model 204</var> version | <dd><var class="product">Model 204</var> version 6.1 or earlier | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
If a Hash-Key Record cannot be stored on the page to which its hash-key hashes, | |||
Model 204 will attempt to store that record on the next physical page in that file and is said to have spilled to that page. | |||
HASHSPIL determines the number of times Model 204 will attempt to store a record on a spilled page and therefore, the spill chain length. | |||
Long hash spill chains may affect performance as more records may have to be retrieved before the desired record is located. | |||
[[Category:Parameters]] | [[Category:Parameters]] | ||
[[Category:System parameters]] | [[Category:System parameters]] | ||
Latest revision as of 18:37, 10 February 2025
Hash file spill chain length
Summary
- Default value
- 16
- Parameter type
- System
- Where set
- User 0 parameter line
- Related products
- All
- Introduced
- Model 204 version 6.1 or earlier
Description
If a Hash-Key Record cannot be stored on the page to which its hash-key hashes, Model 204 will attempt to store that record on the next physical page in that file and is said to have spilled to that page.
HASHSPIL determines the number of times Model 204 will attempt to store a record on a spilled page and therefore, the spill chain length. Long hash spill chains may affect performance as more records may have to be retrieved before the desired record is located.