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

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

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.