Summary information |
|
|---|---|
Default value |
512 |
Range of values |
512–32768 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
The cis packet size parameter specifies the size of Tabular Data Stream™ (TDS) packets that are exchanged between the server and a remote server when a connection is initiated.
The default packet size on most systems is 512 bytes, and this may be adequate for most applications. However, larger packet sizes may result in significantly improved query performance, especially when text and image or bulk data is involved.
If a packet size larger than the default is specified, and the requested server is a System 10 or later Adaptive Server, then the target server must be configured to allow variable-length packet sizes. Adaptive Server configuration parameters of interest in this case are:
additional netmem
maximum network packet size
