Setting the correct network packet size can greatly increase the performance of Adaptive Server.
The -A size option specifies the network packet size to use for an isql session. The default value is 2048 bytes. To set the packet size to 4096 bytes for the current isql session, enter:
isql -A 4096
To check your network packet size, type:
select * from sysprocesses
The value for this isql session appears under the network_pktsz heading in the sysprocesses table.
See the System Administration Guide for more information about setting the network packet size.
