I recommend hard limiting the items loaded from the server, in combination with scrolling. For example, load 100 items (should be fast enough), but display only 10. The other 90 can be checked by scrolling, while it is rather obvious that its easier to reduce the list by typing more.
Jörn On Wed, Jan 28, 2009 at 10:07 PM, Saumin <saumin.pa...@gmail.com> wrote: > > hi, > we are using the autocomplete plugin by bassistance.de. Our business > people want the users to search database with half a million rows. We > have minChars set as 3, but then also some combinations get around > 5000 rows. In that case, the user has to wait for at least 20+ > seconds. I know that the database query comes back with results in > less than 1 second, but the function filllist() takes lot of time as > there are lot of records. Is there anything somebody can suggest to > make it load faster? If not, i wanted to introduce paging in this > control. Has this been done? I would really appreciate a quick > response. > > Thanks! > >
