{ Compress | COMP }={ YES | NO }

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

NO

The packets sent between a SQL Anywhere client and database server can be compressed using the Compress (COMP) connection parameter. Compressing a connection may improve performance under some circumstances. Large data transfers with highly compressible data tend to get the best compression rates.

If a value is not set for the Compress connection parameter, the compression status is controlled by the setting on the database server, which defaults to no compression. If the client and database server settings are different, the client setting applies.

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 database server, use the -pc server option.

Same-computer connections over any communication link do not enable compression, even if the -pc option or COMPRESS=YES parameter is used.

• Connection parameters and connection strings
• -pc dbsrv12 server option
• Communication compression settings
• Use compression carefully

The following connection string fragment turns packet compression on:

Compress=YES

The following connection string fragment turns packet compression off:

Compress=NO