Table size

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 01 June 2006 18:06
> To: valentina at lists.macserve.net
> Subject: Re: Table size
> 
> On 6/1/06 7:03 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> > Hi,
> > 
> >  have table with 177 fields (109 double + 68 byte), this table adds 
> > almost 6MB to my db.dat even before any record is added! Is 
> this correct value?
> 
> Yes, if your data total size will be more than 6M then okay.
> 
Do you mean all records added to Table? 109 * 8 byte + 68 * 2 byte = 1008
byte, < 1k per record - why table so big with no record in!!??

> In case data small, i.e. You need small db you can reduse 
> this Using db.SegmentSize
> 
So what does a "cluster" mean in real, I were do things start and end for
what goes into 1 cluster? 1 field = 1 cluster or? In such case why 32KB
default, or wait this cluster also hold field data so when record added
discsize do not grow until whole cluster is full and start new one (adding
new 32 * 177 = 5664KB to disc file)?

In practical sense this mean 32KB segment can hold 4096 8byte fields before
discsize changes? Just trying to understand...

from COM docs:

inSegmentSize The size of one cluster in the database file; default 32KB.

Regards,

Joakim
> > When I ready sizes inside Vstudio I not even come near this value, 
> > maybe I do something wrong creating table and fields?
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>