Random question: Which is faster/better
Posted: Sat Dec 15, 2007 12:20 pm
This is something I've been pondering for awhile.
Let's say I have some items that I want to categorize. I have a categories table that contains the category id and name. Would it be better if I:
A) Added a field called 'category' to the items table that contains the category id it belongs too
B) Created a new table that contains a game id and a category id ti show which game belong to which category
Is either one more appropriate or faster?
Let's say I have some items that I want to categorize. I have a categories table that contains the category id and name. Would it be better if I:
A) Added a field called 'category' to the items table that contains the category id it belongs too
B) Created a new table that contains a game id and a category id ti show which game belong to which category
Is either one more appropriate or faster?