title: Best way to search data for text auto-complete
body: <p>I'm facing a problem where I need to show suggested / auto-complete results below a text field based on the names of people. Should I load everyone into a list and sort as a collection on startup or can I index by name in the database and only SELECT rows where the person's name starts with a given character sequence? </p>
  
  <p>Of course I'd rather not have to keep a potentially huge list in memory, so if someone could suggest how I could go about using SQL here that would be awesome, thanks. </p>