title: Implementing a fast and relevant search for my site (C# ASP.net)
body: <p>My site has a database of widgets, each widget has a name and description. I want to implement a fast and relevant search system on my site, how do I do this?</p>
  
  <p>As a side note, I also implemented tags on those widget. Here is how I implemented (Tell me what you think):</p>
  
  <p>Table widgets: has unique id plus other info for a widget
  Table tag_words: Has unique ID and of course, the tag
  Table tag-widget: Join table that associates a tag to a widget</p>
  
  <p>I've created indexes on both all those columns to make search as fast as possible.</p>