how to display 1 million data from a table on UI

Question

I have a question which might be a very common issue when data increases If I am having a table containing 1 million rows and I want to display it on my browser.

What is the most efficient approach / technique to approach this problem

I assume there should be a concept of pagination or load data as and when the user scrolls down to see more data, but how to hold 1 million data in memory until then, unless I query the table like id>x and id<(x+500) to fetch data in batches of 500..

Kindly share an efficient approach

Thanks

Answer 1

You really don't want a resultset with 1000000 rows. Even if you paginated it, no-one's going sit down and read them all. Just put a limit on (say 1000), put a message on the page saying the results are truncated to 1000 rows, and offer filtering.