Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters


Compress connection parameter [COMP]

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.

See also

The following connection string fragment turns packet compression ON:


The following connection string fragment turns packet compression OFF: