ASA Database Administration Guide
The Database Server
The database server
Database server options
Specifying this option compresses all connections except for same-machine connections. This option can be overridden for a particular client by specifying COMPRESS=NO in the client's connection parameters.
{ dbsrv9 } -pc ...
All operating systems and network servers.
The packets sent between an Adaptive Server Anywhere client and server can be compressed using the -pc
option. Compressing a connection may improve performance under some circumstances. Large data transfers with highly compressible data tend to get the best compression rates.
The default is not to compress connections. Specifying the -pc
option compresses all connections except same-machine connections and TDS connections. TDS connections (including jConnect) do not support Adaptive Server Anywhere communication compression.
Same-machine connections over any communication link will not enable compression, even if the -pc
option or COMPRESS=YES connection parameter is used.
Adjusting communication compression settings to improve performance
Compress connection parameter [COMP]
Try using Adaptive Server Anywhere's compression features