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 21:03
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> On 5/1/06 9:15 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> > I'm not sure what you mean by this, the records was added 
> first then 
> > they have been traversed through and links set up. There is 
> about 207 
> > 000 places and 243 000 zone records.
> 
> I mean:
> 
>     HOW MUCH times you do link.LinkRecords() for this third link?
> 
> You can add counter into your loop to count this.
> 
Ok I put counter for link.Linkrecords

I have 278 Country 207391 Places and 243126 Zones, But last figure is not
really right and I think this is the proble. 243126 is the total amount of
data records each "zone" consists of from 2 upto 100 data records. So there
is not really this amount of zones, it's much less. Any how I linked country
has place and it resulted in exactly 207391 calls to LinkRecords, and I
linked country has zone and also got 243126 so I think this is correct?

I didn't do the third as it's wrong anyway. I do need to creat new structure
and not link Country to Zonedata but country to Zone(identifier) and
possibly need one more table.


> 
> > Yes I will have a look at it now, after reading your other 
> emails. I 
> > have been out in the forest all day.
> 
> Actually you already have found that blow happens in THIRD link.
> 
> --------
> YOU HAVE 
> 
>     Country    (linkCountryHasPlace)    Place
> 
>       N1                N2                 N3
>
I am not sure but think you mean below records for country and places and
links, right?
> Can you give me numbers
>     N1 = 278
>     N2 = 207391
>     N3 = 207391


The below doesn't matter as it has wrong structure anyhow. I need to
refactor it.

Joakim
> 
> 
> ------------------
> Next, you have 
> 
>     Places     (linkPlaceHasZone)       Zone
>       N3             N4                   N5
> 
> Can you give me numbers
>     N4 = ?
>     N5 = ?
> 
> 
> ---------------------
> Again, 
> 
> WE SAY that when you do for EMPTY Binary Link call 
> LinkRecords(r1, r2) you add ONE record into link. You see?
> 
> So how many records are in each table?
> How many records are in EACH link?
> 
> You have 2 links? 
> 
> 
> --
> 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
>