title: What's the best way to display the number of items related to tags?
body: <p>After following <a href="https://stackoverflow.com/questions/20856/how-do-you-recommend-implementing-tags-or-tagging/20871#20871">this</a> recommendation regarding tags tables structure, I've implemented the following design:</p>
  
  <pre><code>Table: Item
  Columns: ItemID, Title, Content
  
  Table: Tag
  Columns: TagID, Title
  
  Table: ItemTag
  Columns: ItemID, TagID
  </code></pre>
  
  <p>I'm facing another problem, I wanna display the number each tag appears in the system. What's the best way to do this in terms of search query / php code that will not cause a severe performance impact (tags count will appear for each item).</p>
  
  <p>Thanks,</p>
  
  <p>Roy</p>