title: How do I build a search with the number of results for each category?
body: <p>I need to show the number of results for a given category, and hide any categories that give no results. </p>
  
  <p>Example: <a href="http://hotjobs.yahoo.com/job-search?kw=developer" rel="nofollow noreferrer">This Yahoo!Jobs page</a> shows the number of results in categories like City, Job Category, Experience etc.</p>
  
  <p>I work in C#/Asp.Net, and fear that our server will choke without some serious caching and sql optimization.</p>
  
  <p>How would you go forward creating a solution like this?</p>