Table structure?

[Ruslan Zasukhin]

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.


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