ParamQuery grid support forum

General Category => Help for ParamQuery Grid (free version) => Topic started by: Anascloud on December 07, 2020, 12:04:41 pm

Title: How to decrease loading time of autocomelete text box.
Post by: Anascloud 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?

Title: Re: How to decrease loading time of autocomplete text box.
Post by: Anascloud on December 08, 2020, 10:03:05 am

Quote from: Anascloud 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?

Title: Re: How to decrease loading time of autocomelete text box.
Post by: paramvir 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.