D.33 HS_LONG_PIECE_TRANSFER_SIZE

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter for Oracle Database Gateway for Sybase.

Property	Description
Default value	64 KB
Range of values	Any value up to 2 GB

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.