-
Title
What are the advantages of implementing compression by configuring SP_XPT_ENABLE_COMPRESSION? -
Description
What are the advantages of implementing compression by configuring SP_XPT_ENABLE_COMPRESSION? -
Cause
General information. -
Resolution
The Compression increases the performance of Export in that more data can be sent across in a given time. This is due to the fact that the data packets are compressed by Export prior to sending them to respective target(s).
Here is the description of the parameter:
SP_XPT_ENABLE_COMPRESSION
This parameter controls the compression of data across TCP/IP.
You can enable compression to reduce the amount of data that SharePlex sends across the network. SharePlex uses LZIP lossless compression. Enabling compression on the source SharePlex instance automatically enables compression to all targets of the source SharePlex instance.
By default compression is disabled. You can enable compression by itself or in conjunction with encryption. For more information about encryption, see the SharePlex Administration Guide.
Default: 0 (disabled)
Range of valid values: 0 or 1 (enabled)
Takes effect: when Export is restarted