I have a category lookup table. Roughly 200 names next to the primary id.
For integrating content onto the site, I intend on varying the name col(adding col's for this) twice. Each of these values could be two-to-three work phrases, then also either adding couple columns for associated text descriptions(<300 characters for this) or linking to text document. //Though trying to keep content in the table, for ease of update/organization.
This could be considered a single entity, with this by far the busiest table & central to the whole site, with these added col's being searched-on much less, would it make sense to move them onto another table? Does it really matter as long as the searched on col's for each purpose wherever applied are identified in the SELECT queries?
