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?

Another field is of type Blob.
How does the segment-size affects the unused space?
It seems, that the minimum segment-size is 128?

Best 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!
***************************************/