Subject | RE: Helen [IBO] Foreign Key |
---|---|
Author | Nico Callewaert |
Post date | 2001-04-03T13:26:21Z |
That's ok Geoff, thanks a lot,
Nico
-----Oorspronkelijk bericht-----
Van: Geoff Worboys [mailto:geoff@...]
Verzonden: dinsdag 3 april 2001 15:15
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: Helen [IBO] Foreign Key
Nico,
You may be interested in reading the following article as Claudio's
site...
http://www.cvalde.com/document/declaRefIntegVsTrig.htm
Just remember what Helen had to say about performance problems with
FKs for lookup tables - perhaps also remembering my own little
addition that those performance problems are usually only important if
you are dealing with high volume tables. (I think anything over about
10-20 thousand records should be considered high volume in this
regard, although it all depends on how the table and FKs are used.)
Geoff Worboys
Telesis Computing
Yahoo! Groups Sponsor
Click Here to Find Software Faster
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Nico
-----Oorspronkelijk bericht-----
Van: Geoff Worboys [mailto:geoff@...]
Verzonden: dinsdag 3 april 2001 15:15
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: Helen [IBO] Foreign Key
Nico,
You may be interested in reading the following article as Claudio's
site...
http://www.cvalde.com/document/declaRefIntegVsTrig.htm
Just remember what Helen had to say about performance problems with
FKs for lookup tables - perhaps also remembering my own little
addition that those performance problems are usually only important if
you are dealing with high volume tables. (I think anything over about
10-20 thousand records should be considered high volume in this
regard, although it all depends on how the table and FKs are used.)
Geoff Worboys
Telesis Computing
Yahoo! Groups Sponsor
Click Here to Find Software Faster
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]