Table structure?

[Ruslan Zasukhin]

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.


> 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

Can you give me numbers
    N1 = ?
    N2 = ?
    N3 = ?


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