VistaDB 5

Packed Property
Flag to represent if the column should be packed using LZH compression when written to disk. (False by default)
ReadOnly Property Packed As System.Boolean
Dim instance As IVistaDBColumnAttributes
Dim value As System.Boolean
value = instance.Packed
System.bool Packed {get;}
read-only property Packed: System.Boolean; 
function get Packed : System.boolean
__property System.bool get_Packed();
property System.bool Packed {
   System.bool get();

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)).


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