I have a lookup table:
Pid label
1 hats
2 gloves
3 shirts
And want to integrate some content associated with these items.
hats -- "felt hats, some of the finest..."
gloves -- "fit like they grew that way..."
shirts -- " patterned silk in all shades and styles..."
My question is do I simply add columns to the existing table for this (which is being heavily searched on already) Or do I create a second table and do a basic join for the pages for when only the content is to appear.
The concern is performing so many queires on a table that has so much text. So, should the content be excluded and set off on another table?