title: In continue of questions "DB Schema for storing tagged records" -- how to select list of items with tags?
body: <p>Good day!</p>
  
  <p>There are a lot of questions how to store tags in DB here on stackoverflow, I finally decide to use Toxi approach (items table, tags table and many-to-many intermediate table) <a href="http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html" rel="nofollow noreferrer">http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html</a></p>
  
  <p>I want to display a list of 20-50 tagged items on a page each with list of it's tags (I use LINQ2SQL in ASP.NET 3.5). </p>
  
  <p>I see some options:</p>
  
  <ol>
  <li><p>First query for list of items than run query for each item to select tags for each item -- seems to be slow, but caching on application level can improve situation.</p></li>
  <li><p>Denormalize items table and store list of tags for item in text field in "items" table.</p></li>
  </ol>
  
  <p>However both options seem bad to me, may be I'm missing something?</p>
  
  <p>Thanks in advance!</p>