Number of Records Buffered Property
Description
Specifies the minimum number of records buffered in memory during a query in the block.
Applies to block
Set Oracle Forms
NULL; which indicates the minimum setting allowed (the value set for the Number of Records Displayed property plus a constant of 3).
Required/Optional optional
Usage Notes
- Oracle Forms buffers any additional
records beyond the maximum to a temporary file on disk.
- Improve processing speed by increasing the number of records buffered.
- Save memory by decreasing the number of records buffered. This can, however,
result in slower disk I/O.
- If you anticipate that the block may contain a large number of records either
as the result of a query or of heavy data entry, consider raising the Number
of Records Buffered property to increase performance.
- Consider lowering the Number of Records Buffered property if you anticipate
retrieving large items, such as image items, because of the amount of memory
each item buffered may require.
Number of Records Buffered Restrictions
- If
you specify a number lower than the minimum, Oracle Forms returns an error
when you attempt to accept the value.