FASTGLOB parameter: Difference between revisions
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 15: | Line 15: | ||
==Description== | ==Description== | ||
<p>When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an NTBL offset that points to the NTBL entry for the list or found set is stored in VTBL. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if | <p>When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an <var>[[LNTBL_parameter|NTBL]]</var> offset that points to the NTBL entry for the list or found set is stored in <var>[[LVTBL_parameter|VTBL]]</var>. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if NTBL has been shuffled.) </p> | ||
<p>Enabling this feature causes VTBL entries to expand by eight bytes for each global list or found set. </p> | <p>Enabling this feature causes VTBL entries to expand by eight bytes for each global list or found set. </p> | ||
<p>Valid settings of FASTGLOB are:</p> | <p>Valid settings of FASTGLOB are:</p> | ||
| Line 21: | Line 21: | ||
<tr><th>Setting </th><th>Meaning</th></tr> | <tr><th>Setting </th><th>Meaning</th></tr> | ||
<tr><th align="right"><var>0 </var></th><td>FASTGLOB feature is disabled. References to global lists and found sets require sequential scans of NTBL.</td></tr> | <tr><th align="right"><var>0 </var></th><td>FASTGLOB feature is disabled. References to global lists and found sets require sequential scans of NTBL.</td></tr> | ||
<tr><th align="right"><var>1 </var></th><td>FASTGLOB feature is enabled. A variable containing an | <tr><th align="right"><var>1 </var></th><td>FASTGLOB feature is enabled. A variable containing an NTBL offset, which is stored in VTBL, points to the NTBL entry for the list or found set.</td></tr> | ||
</table> | </table> | ||
[[Category:System parameters]] | [[Category:System parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Latest revision as of 10:34, 21 October 2014
Fast global processing
Summary
- Default value
- 0
- Parameter type
- System
- Where set
- Resettable
- Related products
- All
- Introduced
- Model 204 V6.1
Description
When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an NTBL offset that points to the NTBL entry for the list or found set is stored in VTBL. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if NTBL has been shuffled.)
Enabling this feature causes VTBL entries to expand by eight bytes for each global list or found set.
Valid settings of FASTGLOB are:
| Setting | Meaning |
|---|---|
| 0 | FASTGLOB feature is disabled. References to global lists and found sets require sequential scans of NTBL. |
| 1 | FASTGLOB feature is enabled. A variable containing an NTBL offset, which is stored in VTBL, points to the NTBL entry for the list or found set. |