CompressionLevel Property (Replication)

The CompressionLevel property specifies the amount of compression that will be used by the compression routines during replication.

Syntax

object.CompressionLevel [= value]

Parameters

  • value
    The compression level to use. Valid values are 0 to 6 (inclusive), with a setting of 0 representing no compression and a setting of 6 enabling maximum compression. The default value is 1.

Applies To

SQL Server 2005 Compact Edition Replication object

Data Type

short

Modifiable

Read/write

Prototype

HRESULT get_CompressionLevel(short *pVal);
HRESULT put_CompressionLevel(short newVal);

Remarks

The CompressionLevel property lets you customize compression to meet your specific needs. A lower value causes the compressor to run more quickly, but the data transmitted is not a tightly compressed and therefore takes longer to transmit. A higher compression level value will cause more processing on the server running IIS, but will reduce data transfer times.

A value of 0 turns off all compression. The default value is 1. This uses the lowest amount of processor time while still providing some compression.

The actual amount of data compression depends on the type of data being compressed.

See Also

Reference

Replication Object Properties

Help and Information

Getting SQL Server Compact Edition Assistance