I use LIKE queries in other areas, but they aren't fast enough for key by key suggestions. A memory search tree could work, but that essentially re-implementing solr. I suggested solr because someone who has experience with auto-complete suggested it. 
posted by yegg Staff7 years and 7 months ago Link