Author Topic: How to decrease loading time of autocomelete text box.  (Read 2006 times)

Anascloud

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 3
    • View Profile
How to decrease loading time of autocomelete text box.
« on: December 07, 2020, 12:04:41 pm »
Hi,

We are having a icon/button on the grid. By clicking on that button it loads data from table and shows into a autocomplete text box.
We are having 10-20 thousands records in a table.
But whenever we click on button it is taking about 1 minute to load all records.

How can we cache or somehow store the table data on browser temporarily so that we can re-use it and load the data faster?
Is there any other way to reduce the time taken by drop down to load the data?

Anascloud

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: How to decrease loading time of autocomplete text box.
« Reply #1 on: December 08, 2020, 10:03:05 am »
Hi,

We are having a icon/button on the grid. By clicking on that button it loads data from table and shows into a autocomplete text box.
We are having 10-20 thousands records in a table.
But whenever we click on button it is taking about 1 minute to load all records.

How can we cache or somehow store the table data on browser temporarily so that we can re-use it and load the data faster?
Is there any other way to reduce the time taken by drop down to load the data?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to decrease loading time of autocomelete text box.
« Reply #2 on: December 09, 2020, 10:32:33 am »
jQueryUI autocomplete renders the DOM of all items, hence it gets slow for large dataset.

I'm looking into using pqgrid itself, which is based on virtual rendering as autocomplete component in upcoming versions.