# 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.

Parent topic: Setting Network Server properties
Related reference
derby.drda.host property
derby.drda.keepAlive property
derby.drda.logConnections property
derby.drda.maxThreads property
derby.drda.minThreads property
derby.drda.portNumber property
derby.drda.securityMechanism property
derby.drda.sslMode property
derby.drda.startNetworkServer property
derby.drda.timeSlice property
derby.drda.traceAll property
derby.drda.traceDirectory property