title: How do I get this lightning fast search?
body: <p>I just came over this site: <a href="http://www.hittaplagget.se" rel="nofollow">http://www.hittaplagget.se</a>. If you enter the following search word <code>moo</code>, the autosuggest pops up immediately.</p>
  
  <p>But if you go to my site, <a href="http://storelocator.no" rel="nofollow">http://storelocator.no</a>, and use the same search phrase (in "Search for brand" field), it takes a lot longer for autosuggest to suggest anything.</p>
  
  <p>I know that we can only guess on what type of technology they are using, but hopefully someone here can do an educational guess better than I can.</p>
  
  <p>In my solution I only do a <code>SELECT moo% FROM table</code> and return the results.
  I have yet not indexed my table as there are only 7000 rows in it. But I'm thinking of indexing my tables using Lucene.</p>
  
  <p>Can anyone suggest what I need to do in order to get equally fast autosuggest?</p>