ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

Compress connection parameter [COMP]

Function 

To turn 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 Adaptive Server Anywhere communication compression.

Values 

YES, NO

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

Default 

NO

If no Compress value is set, the compression status is controlled by the setting on the server, which defaults to no compression.

Description 

The packets sent between an Adaptive Server 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.

Available values of the Compress (COMP) connection parameter are case insensitive, and include:

• YES    Turn communication compression on for this connection.

• NO    Turn communication compression off for this connection.

To save yourself time and possible disappointment, it is wise to 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-machine connections over any communication link will not enable compression, even if the -pc option or COMPRESS=YES parameter is used.

Examples 

• The following connection string fragment turns packet compression ON:

  Compress=YES

• The following connection string fragment turns packet compression OFF:

  Compress=NO

See also 

-pc server option

Adjusting communication compression settings to improve performance