derby.drda.streamOutBufferSize property

Configures the size of the buffer for streaming blob/clob data from server to client.

If the configured size is 0 or less, the buffer is not placed.

Note: This configuration is used when optimizing streaming blob/clob from server to client.

If there were found many small packets, of which sizes are much lower than maximum size of packet possible in the network, it will improve performance of streaming to setting this configuration.

Recommended value of this configuration is maximum packet size possible in the network minus appropriate size for header.

Syntax

derby.drda.streamOutBufferSize=sizeOfBuffer

Default

0 (zero).

Example

derby.drda.streamOutBufferSize=1024

Static or dynamic

Dynamic. You can change system values by using commands after the Network Server has been started.