Size of database

Ruslan Zasukhin sunshine at public.kherson.ua
Thu May 28 12:04:51 CDT 2009


On 5/28/09 7:56 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

>>> Another field is of type Blob.
>>> How does the segment-size affects the unused space?
>>> It seems, that the minimum segment-size is 128?
>> 
> I also found the VVarBinary()-class. Can I use this one instead of a
> Blob-Field with better use of diskspace? Is reading same fast?

The smaller disk the faster read :)

Yes you can use VarBinary of course instead of VBLOB, for small objects,
Say < 128 bytes.


ZIP compressions works for BLOBs only.
ZIP may give up to 7 times compressions avg.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list