|
![CharSet connection parameter [CS]](gif/backward.gif)
Sets the maximum size of communication packets, in bytes.
Anywhere
Integer [ k ]
If no CommBufferSize value is set, the CommBufferSize is controlled by the setting on the server, which defaults to 1460 bytes.
The CommBufferSize (CBSIZE) connection parameter specifies the size of communication packets, in bytes. Use k to specify units of kilobytes. The minimum value of CommBufferSize is 300 bytes, and the maximum is 16000 bytes.
The protocol stack sets the maximum size of a packet on a network. If you set the CommBufferSize to be larger than that permitted by your network, the largest buffers are broken up by the network software. You should set the buffer size to be somewhat smaller than that allowed by your network because the network software may add information to each buffer before sending it over the network. The default of 1460 allows an ethernet packet to be completely filled when using TCP/IP.
A larger packet size may improve performance for multi-row fetches and fetches of larger rows, but it also increases memory usage for both the client and the server.
If CommBufferSize is not specified on the client, the connection uses the server's buffer size. If CommBufferSize is specified on the client, the connection uses the CommBufferSize value.
Using the -p database server option to set the CommBufferSize causes all clients that do not specify their own CommBufferSize to use the size specified by the -p database server option.
To set the buffer size to 400 bytes:
... CommBufferSize=400 ...
Alternatively, you can set this parameter by entering its value in the Buffer Size text box on the Network tab of the ODBC Configuration dialog.