D.36 HS_RPC_FETCH_SIZE
HS_RPC_FETCH_SIZE
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default value |
|
Range of values |
|
Tunes internal data buffering to optimize the data transfer rate between the server and the agent process.
Increasing the value can reduce the number of network round-trips needed to transfer a given amount of data, but also tends to increase data bandwidth and to reduce latency as measured between issuing a query and completion of all fetches for the query. Nevertheless, increasing the fetch size can increase latency for the initial fetch results of a query, because the first fetch results are not transmitted until additional data is available.
Parent topic: Initialization Parameters