After following [this](https://stackoverflow.com/questions/20856/how-do-you-recommend-implementing-tags-or-tagging/20871#20871) recommendation regarding tags tables structure, I've implemented the following design:

```
Table: Item
Columns: ItemID, Title, Content

Table: Tag
Columns: TagID, Title

Table: ItemTag
Columns: ItemID, TagID

```

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).

Thanks,

Roy