Ansicht
Dokumentation

dbs/inf/select_buffer_size - size of buffer for 'array fetch' or 'bulk fetch'

dbs/inf/select_buffer_size - size of buffer for 'array fetch' or 'bulk fetch'

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/inf/select_buffer_size |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short description : size of buffer for 'array fetch' or 'bulk fetch' |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
This parameter defines the size of the data buffer, in which
| data records read by 'array fetch' (explicit pre-fetch from |
| Informix), or the 'home rows' (data records without the extra BLOB |
| data) of the data records read by 'bulk fetch' (implicit pre-fetch |
| from Informix), are written. |
| |
| |
| |
| The choice of Informix pre-fetch is made with the profile parameter |
| 'dbs/inf/array_fetch_off'. |
| Also read the description of this parameter. |
| |
| The size of the buffer determines implicitly the number of |
| data records transferred in a packet. This packet is a logical |
| packet, which is split up by the network software |
| if necessary. |
| |
'Bulk fetch' is generally not used very often as 'array fetch'
is normally much more efficient. 'Bulk fetch' is only useful in
exception situations (e.g. 'select for update').
| |
Caution:
| -------- |
The default value is generally the best value. A different value
can have a negative influence on performance.
------------------------------------------------------------------------

------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Unit: Bytes |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Default : 67584 ('array fetch'), 32767 ('bulk fetch') |
------------------------------------------------------------------------

------------------------------------------------------------------------
Who is permitted to make changes: SAP
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for database systems: Informix |
------------------------------------------------------------------------

------------------------------------------------------------------------
Are other parameters affected or dependent: No
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
| - 'bulk': Whole number between 33,792 (33K) - 1,081,344 (1,056K) |
| - 'array': Whole number between 0 - 32,767 (32K-1) |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : size of buffer for 'array fetch' or 'bulk fetch'
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Minimum : 0
------------------------------------------------------------------------

------------------------------------------------------------------------
| Maximum : 1081344
------------------------------------------------------------------------


TXBHW - Original Tax Base Amount in Local Currency   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 6381 Date: 20240328 Time: 231456     sap01-206 ( 5 ms )