Size of database

[Thomas Flemming]

Hi,

>> I'm trying to take care of the size of my databases on disk.
>>
>> I have a table with mio of records.
>> One field contains a name, which is a StringField of 40 chars size.
>> Unfortunally almost 80% of all data have a name much shorter then 40, so here
>> is a lot of space "wasted".
>> Is it maybe better to use a TextField in this case? What about the compression
>> flag?
> 
> You can try VarChar(40)
Wow, thats good, saves me 10% of diskspace.

>  
>> 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?

Regards,
Tom




-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/