I am implementing a tagging system on my website similar to one stackoverflow uses, my question is - what is the most effective way to store tags so that they may be searched and filtered?
My idea is this:
Table: Items Columns: Item_ID, Title, Content Table: Tags Columns: Title, Item_ID
Is this too slow? Is there a better way?