dotConnect for MySQL Documentation
Compress Property
See Also  Send comments on this topic.
Devart.Data.MySql Namespace > MySqlConnection Class : Compress Property

Gets or sets a value indicating whether to enable transferred data compression.


Visual Basic (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.


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.


Platforms:Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family, Windows 7, Windows 8, Windows 10, Windows Server 2012 family.

See Also