What's the best practices paging while ordering with large amount of rows?
What's the best practices paging while ordering with large amount of rows?
bikai
Posts: 21Questions: 12Answers: 0
I have a large amount of rows, more than 100,000 records, in a table which cols could be reordered.
when querying a page, the back-end(wrote in java) needs to query all the rows, reorder them, then return the specific page.
this will be quite slow, anyone has any ideas to make this faster?
This discussion has been closed.
Answers
Are you using server-side processing? If not, then that might be one option as it off loads the heavy lifting to a database which has been specifically designed to sort data sets.
Allan