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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

compression option [SQL Remote]

Sets the level of compression for SQL Remote messages.

Allowed values

Integer, from -1 to 9



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY USER DEFINED OPTION Yes Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily? No No No

The values have the following meanings:

  • -1

    Send messages in version 5 format. The Message Agent from version 5 cannot read messages sent by the Message Agent from version 6 and later. Ensure that the compression option is set to -1 until all Message Agents in your system are upgraded to version 6 or later.

  • 0

    No compression.

  • 1 to 9

    Increasing degrees of compression. Creating messages with high compression can take longer than creating messages with low compression.