title: Best performance for tags in mysql/php
body: <p>I have one table with items and one table with tags that can be linked to the items. Should I create a table where I store the relations between them or can I store the tag ids right in the item table like a column with "1,52,375" (tag ids).</p>
  
  <p>I would in most cases lean towards a relation table, but I will mostly add one single tag per item and at the most 10 so I wonder if it's worth it.</p>
  
  <p>If going with the relation table will I need a "loop-in-loop" where I make one query per item to fetch the tags. It seems like a lot of queries or is there a different solution?</p>
  
  <p>I could also fetch all the items and tags separately in two queries and link them with php. Also loop in loop, but less database queries.</p>
  
  <p>What do you think? Thanks!</p>