Packed Property

In This Topic

Flag to represent if the column should be packed using LZH compression when written to disk. (False by default)

Syntax

Visual Basic
C#

'Declaration
 
ReadOnly Property Packed As System.Boolean

'Usage
 
Dim instance As IVistaDBColumnAttributes
Dim value As System.Boolean
 
value = instance.Packed

System.bool Packed {get;}

Remarks

Packing a column that has a lot of redundant text can result in considerable space savings on disk. However, packing and unpacking the data for retrieval adds extra CPU needs to the column. Performing like or where clause operations on a packed column that is not indexed will be considerably slower than a normal column. This only applies when the data is written to disk; a 100MB column compressed to 10MB will still consume 100MB when loaded into a Row or DataSet.

This flag is only used by Text, NText, and Image column types (large object data types, also known as VarChar(MAX), NVarChar(MAX), and VarBinary(MAX)).

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

Reference

IVistaDBColumnAttributes Interface
IVistaDBColumnAttributes Members

Send Feedback