Summary information |
|
|---|---|
Default value |
512 |
Range of values |
512–32768 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
Configuration group |
Component Integration Services |
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, unitext, and image or bulk data is involved.
If you specify a packet size larger than the default, and the requested server is a version 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
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
