D.33 HS_LONG_PIECE_TRANSFER_SIZE
HS_LONG_PIECE_TRANSFER_SIZE
initialization parameter for Oracle Database Gateway for Sybase.
Property | Description |
---|---|
Default value |
|
Range of values |
Any value up to |
Sets the size of the piece of LONG
data being transferred. A smaller piece size means less memory requirement, but more round-trips to fetch all the data. A larger piece size means fewer round-trips, but more of a memory requirement to store the intermediate pieces internally. Thus, the initialization parameter can be used to tune a system for the best performance, with the best trade-off between round-trips and memory requirements, and network latency or response time.
Parent topic: Initialization Parameters