dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlConnection Class / Compress Property

In This Topic
    Compress Property (MySqlConnection)
    In This Topic
    Gets or sets a value indicating whether to enable transferred data compression.
    Syntax
    'Declaration
     
    Public Property Compress As Boolean
    public bool Compress {get; set;}

    Property Value

    true, if transferred data compression enabled; otherwise false. The default value is false.
    Remarks

    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.

    When a value is assigned to this property, the MySqlConnection is closed.

    Requirements

    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

    See Also