I'm wondering what source of data would be best for an autocomplete input box (using AJAX). Currently I have it looking for matches in a MySQL database using LIKE, but I'm worried about the multiple, consecutive hits while the person is typing (I do have a delay, but it still could be a considerable number of queries if multiple people are typing at the same time). Would searching a flatfile (CSV or XML) be any more efficient, or is the DB the way to go? If flatfile would be better, what format would you suggest (any good functions/classes out there)? If DB is the better route, is LIKE ok, or would fulltext be better? We're talking a little over 2,000 records to search a title field, currently.
Thanks!
Matt