[SOLVED]Database efficiency question
Posted: Tue Mar 07, 2006 2:16 pm
Hi,
I have three tables (many-to-many):
USER
USER_TAG_LINK
TAG
In the USER table the user specifies a field of interest and then in the TAGS table they specify a set of descriptive tags.
What I want to do is when the user is entering tags, present the user with a jump menu that contains tags that other users in the same field of interest have already submitted.
In terms of database / server load would it be best to also enter the field of interest alongside the tags in the TAG table (as well as the USER table) as an extra field or remove the field of interest into a separate table - give it an id_number and store this in the USER and the TAG table instead?
Or would it not make a difference?
Does all that make sense?
Thanks in advance.
jb
I have three tables (many-to-many):
USER
USER_TAG_LINK
TAG
In the USER table the user specifies a field of interest and then in the TAGS table they specify a set of descriptive tags.
What I want to do is when the user is entering tags, present the user with a jump menu that contains tags that other users in the same field of interest have already submitted.
In terms of database / server load would it be best to also enter the field of interest alongside the tags in the TAG table (as well as the USER table) as an extra field or remove the field of interest into a separate table - give it an id_number and store this in the USER and the TAG table instead?
Or would it not make a difference?
Does all that make sense?
Thanks in advance.
jb