Chapter 3 Connection and Communication Parameters
51
If you supply a value for CharSet, the specified character set is used for the
current connection.
$ For a list of valid character set values, see "Character set labels" on
page 300 of the book ASA User’s Guide.
CommBufferSize connection parameter [CBSize]
To set the maximum size of communication packets, in bytes.
Anywhere
Integer
1024
The CommBufferSize parameter specifies the size of communications
packets, in bytes. The minimum value of CommBufferSize is 300, and the
maximum is 16000. If the specified packet size is larger than that of the
database server, the server’s packet size is used.
The maximum size of a packet on a network is set by the protocol stack. If
you set 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.
A larger packet size improves performance for multi-row fetches and fetches
of larger rows. As each connection has its own pool of buffers, a large buffer
size increases the memory usage. The application side uses four default-sized
buffers per connection, and on the server side, there are two.
This corresponds to the SQL Anywhere Version 5
dbclient
–p command-line
switch.
The value is a global setting: the value is set on the first connection attempt
for a session, and that value is used for all connections until the client library
is closed down.
♦ To set the buffer size to 400 bytes:
...
CommBuffSize=400
...
Alternatively, you can set this parameter by entering its value in the Buffer
size text box of the Network tab of the connection window.
Description
Function
Usage
Values
Default
Description
Examples
To Next Page
Loading...