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. For example, to set the packet size to 2048 bytes for the current isql session, enter:
In UNIX platforms:
isql -A 2048
In Windows NT:
load isql -A 2048
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.
