Author Topic: Update multiple Grids with many rows  (Read 353 times)

pranit@srcomsec

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 99
    • View Profile
Update multiple Grids with many rows
« 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]
});

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Update multiple Grids with many rows
« Reply #1 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.

pranit@srcomsec

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 99
    • View Profile
Re: Update multiple Grids with many rows
« Reply #2 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?
« Last Edit: November 17, 2022, 11:48:46 am by pranit@srcomsec »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Update multiple Grids with many rows
« Reply #3 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?
« Last Edit: November 18, 2022, 06:46:06 am by paramvir »