Compress connection parameter [COMP]

Turns compression on or off for a connection. Compressing a connection may improve performance under some circumstances.

Usage

Anywhere except with TDS connections. TDS connections (including jConnect) do not support SQL Anywhere communication compression.

Values

YES, NO

In the case of a difference between client and server settings, the client setting applies.

Default

NO

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.

Remarks

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.

See also
Examples

The following connection string fragment turns packet compression ON:

Compress=YES

The following connection string fragment turns packet compression OFF:

Compress=NO