Compressing data leads to reducing network traffic, in exchange for CPU usage on both client and server sides. When using Compress, keep in mind the following nuances.
MySQL applies compression to every packet, including small ones. When trying to compress small amount of data, the resulting archive is actually bigger than source data block (because of headers and other auxiliary information). Thus, using compression in queries that do not transfer BLOB data causes network load to be heavier. To obtain performance gains, use Compress property when transferring *BLOB (*TEXT) fields.
Currently data compression is not supported in direct access mode. If you wish to use it, set Direct to false.
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2