Re: database's table design with similar foreign keys

You are right and I regret my poor choice of words. What I meant to say is that, given even a few thousand cities, the size increase of the database should be relatively small in the context of today's multi-gigabyte hard drives.

JMG Gene Wirchenko wrote:

> Jim Gross <jmgross_at_worldnet.att.net> wrote:
>
> [snip]
>
> >Finally, if none of the above workarounds appeal to you, go with the simpler
> >solution and populate the duplicates and same-city records. You probably
> >wouldn't notice any difference in performance and I'm sure the redundancy
> >won't use up that much additional disk space.
>
> It will *double* it (assuming no same-city records).
>
> >Good luck.
>
> [snipped previous]
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
Received on Mon Jan 10 2000 - 00:00:00 CET