Enabling compression for one or all connections, and setting the minimum size at which packets are compressed, can improve SQL Anywhere performance in some circumstances. Therefore, you should perform a performance analysis on your network with your applications to determine whether changing the compression threshold is beneficial.
Enabling compression increases the quantity of information stored in data packets, thereby reducing the number of packets required to transmit a particular set of data. By reducing the number of packets, the data can be transmitted more quickly.
To determine if enabling compression will help in your particular situation, conduct a performance analysis on your network using your applications before using communication compression in a production environment.
You can tune compression performance by:
Enabling compression Enabling compression for a connection (or all connections) can significantly improve SQL Anywhere performance under some circumstances, including:
When used over slow networks such as some wireless networks, some modems, serial links, and some WANs.
When used with SQL Anywhere encryption over a slow network with built-in compression since packets are compressed before they are encrypted.
Enabling compression, however, can sometimes also cause slower performance. For example:
Communication compression uses more memory and more CPU. It may cause slower performance, especially for LANs and other fast networks.
Most modems and some slow networks already have built-in compression. In these cases, SQL Anywhere communication compression will not likely provide additional performance benefits unless you are also encrypting the data.
Modifying the compression threshold
For most networks, the compression threshold does not need to be changed. In rare circumstances, you might adjust the compression threshold to improve SQL Anywhere performance.
To determine if modifying the compression threshold will help in your particular situation, conduct a performance analysis on your network using your applications before making any adjustments in a production environment.
Because CPU time is required to compress packets, attempting to compress small packets can actually decrease performance.
In general, lowering the compression threshold value may improve performance on very slow networks, while raising the compression threshold may improve performance by reducing CPU usage. However, since lowering the compression threshold value increases CPU usage on both the client and server, a performance analysis should be done to determine whether changing the compression threshold is beneficial.
Adjusting SQL Anywhere compression settings
Enable communication compression.
Large data transfers with highly compressible data and larger packet sizes tend to get the best compression rates.
Adjust the CompressionThreshold setting.
Lowering the compression threshold value may improve performance on very slow networks, while raising the compression threshold may improve performance by reducing CPU usage.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|