Size of database

[Ruslan Zasukhin]

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

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

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]