FASTGLOB parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(One intermediate revision 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 <var>[[LNTBL_parameter|NTBL]]</var> 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 NBTL has been shuffled.) </p>
<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 NBL offset, which is stored in VTBL, points to the NTBL entry for the list or found set.</td></tr>
<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.