You guys who have used auto-complete with jquery, or yui... How did you go about the database part?
When one builds an auto complete feature for a website, how many queries are usually sent to the database?
For example, suppose I type "q" in a text box
I could issue a query like
Select * FROM names where name like 'q';
Then for the next letter "u"
"Select * FROM names where name like 'qu';
I could run a query for every letter that is inputted in the text box, but a database transaction for every letter seems very costly.
I want your input. How do you implement the data retrieval of auto-complete.