Showing 1 million rows in a browser

Question

Our Utilty has one single table, and it has 10 million to 50 million rows, There may be a case we need to show 50 million rows in a single page html client page, To show the rows in browser we use jQuery in UI.

To retrieve rows we use Hibernate and use Spring for MVC. I am looking for best practice in retrieving the rows and showing in UI. Should I retrieve a bulk of thousands rows or two thousand rows in Hibernate and buffer to Web Client or a best practice is there ?

Answer 1

The best practice is not to do this. It will explode the browser memory and rendering engine, and will take too much time to load.

Add a search form to your webapp, make the end user search for what he's interested about, and only display the N first search results, just like Google does.

Nobody is able to do anything meaningful with 50 million rows without searching anyway.