> From: "Yury V. Bukhman" <[EMAIL PROTECTED]>
> Organization: Danforth Plant Science Center
> Date: Tue, 16 Jan 2001 16:49:09 -0800
> To: Anthony Cooke <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Char comparisons vs. Integer.
>
>
> Do you mean, putting primary entry identifiers of all 4 databases into each
> table
> instead of using the cross-reference tables? That won't work because in
> general
> there is a many-to-many relationship between entries in my databases. For
> many-to-many relationships, one has to have the cross-reference tables.
>
Hi,
Multiplying the keys by cross mixing them in every table in every database
is not what I had in mind. From what what I understood you would pull
mostly from the attributes or dimensions within one collection based on a
key on the main "entries". Therefore I believe that keying within a
database is a correct approach. I do not doubt the relationships and
constraints have been well thought out on your end and cross reference
tables are necessary. I have but a limited view of the situation.
IMHO The benefit of having the ID key as an integer is the reduced space
required to store it with regards to a char equivalent. This of course goes
for both the data and index files. If all the database is to be stored in
memory then space must be a premium and repeating the char value of the key
for each record in every table seemed expensive.
Saludos,
Anthony Cooke
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
