ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: pranit@srcomsec on November 16, 2022, 08:22:33 pm

Title: Update multiple Grids with many rows
Post by: pranit@srcomsec on November 16, 2022, 08:22:33 pm

We have a requirement to display 8 or more grids on the screen and each grid has 1500 rows.

We need to update all grids together every second. Currently, this process is taking more than 10 seconds to update all grids.

Is there a way to update all gird quickly? We are already using multiple row updates. See the sample below.

Code: [Select]

$("#gridfilter1").pqGrid("updateRow", {
rowList: [Array List]
});


Title: Re: Update multiple Grids with many rows
Post by: paramvir on November 17, 2022, 07:03:45 am

I guess you mean it takes 10 second to fetch remote data for all grids.

You might need to rethink your design, fetch and update the data only when it's changed rather than brute and force method to update the grids data every second.

Title: Re: Update multiple Grids with many rows
Post by: pranit@srcomsec on November 17, 2022, 11:41:16 am

Thank you for your response.

We are using the grid for the stock market to display data like stock rate, ATP, etc... which is updated every second.

Any suggestion to update all?

Title: Re: Update multiple Grids with many rows
Post by: paramvir on November 17, 2022, 10:45:34 pm

How are you fetching the data for all the grids? Do you send single request for all grids or separate requests for different grids.

What's the dataModel.location value.

Do you fetch only changed data or only the updated data?

Do you update all the rows or only the rows / cells which have changed?