Table structure?

[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 May 2006 12:56
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> On 5/1/06 12:43 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> > Either I am doing something wrong if this increase is 
> unnormal, as for 
> > CountryHasPlace there are 279 RecId on One side creating links to 
> > 207391 places on the Many side, I guess that will be equal 
> to 207391 
> > Binary links between these 2 tables? And for Country-Zones 
> this figure is 279 and 243126.
> 
> Yes - 207,391 pairs will go into BinaryLink.
> 
> I can say minimal size current will be 24, avg 36 bytes per pair.
> 
> So in your case expected size of Binary Link should be 7.46 Mb.
> 

But this is a bit strange as it's much more then if I simply keep my Primary
key. Well I will look at it again.

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