Hi,
I’m not sure how the scrolling and server-side paging actually works under the hood, but I have a feeling that both queries all the records for each user interaction (scrolling down in case of scrolling, going to next page in case of paging).
We’ve got a query that returns a massive amount of records and I’d like to find an efficient solution to display that data in jqxGrid.
Would you please tell how each approach works and renders the data on the screen and what’s the best practice in case of mass data?
Is there a solution that queries the records once only and renders the data on-demand from that result without querying the whole over & over again?
If I get it right, server-side pagination works in a way that every time the user clicks the next page, the whole query is evaluated, but returns only the next section of it, then it gets rendered on the screen. With this I’d like to have a solution that saves the query into the memory for the first run and when user goes to the next page, it rather renders the grid from that saved data. If possible, I’m afraid it’s not…
Scrolling works in a way that for every scroll, the whole query runs each time and renders the next section. Neither this solution sounds efficient to me.
In short: is there a solution which runs the query only once?
Thanks in advance!
Karoly