Autocomplete Combobox backed by database
I'm quite comfortable using AutoCompleteDecorator on a combobox where the entries in the List<?> items have been populated in advance. However, this leads to a performance issue when the list contains several thousand entries. What I would like to do is just show the first few (maybe 10) matching entries from the database as the user types in the combobox. With each new character entered in the combobox I will then need to retrieve fresh data from the database. Clearly this needs to be done with care if performance is not to suffer.
Can you offer any advice on how to achieve this?