Turns compression on or off for a connection. Compressing a connection may improve performance under some circumstances.
Anywhere except with TDS connections. TDS connections (including jConnect) do not support SQL Anywhere communication compression.
In the case of a difference between client and server settings, the client setting applies.
If a value is not set for the Compress connection parameter, the compression status is controlled by the setting on the server, which defaults to no compression.
The packets sent between a SQL Anywhere client and server can be compressed using the Compress (COMP) connection parameter. Large data transfers with highly compressible data tend to get the best compression rates.
Specify YES or NO to turn communication compression on or off for the connection. They are case insensitive.
It is recommended that you conduct a performance analysis on the particular network and using the particular application before using communication compression in a production environment.
To enable compression for all remote connections on the server, use the -pc server option.
Note that same-computer connections over any communication link will not enable compression, even if the -pc option or COMPRESS=YES parameter is used.
The following connection string fragment turns packet compression ON:
The following connection string fragment turns packet compression OFF:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|