Author Topic: Accommodate huge data in pq grid  (Read 2225 times)

marcus

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 7
    • View Profile
Accommodate huge data in pq grid
« on: October 01, 2018, 12:55:45 pm »
Hello,

Just wanted to know whether its possible to accommodate > 2000 columns and more than 10 million data in pq grid ?
If yes, then how system performance will be ?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
    • View Profile
Re: Accommodate huge data in pq grid
« Reply #1 on: October 01, 2018, 10:40:16 pm »
Good news is pqgrid is the only js grid to handle as much data as possible, in any case more than any other grid.

But you should be concerned about loading that much data in the browser. My guess is that much data would be much more than 100MB in size.

you would need to configure remote server to increase maximum size of response and timeout and compression of payload.

Or you can have a look at loading data in increments example:  https://paramquery.com/pro/demos/infinite_scroll

marcus

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Accommodate huge data in pq grid
« Reply #2 on: October 02, 2018, 07:43:14 pm »
Thanks for your quick response :)
I will go through the example which you have shared and let you know in case of any queries.