10,000 + records on html to render quickly

Question

Now this is going to be a very absurd question. But what can I do, it's the client's requirement. Basically, we have a grid (master-detail type) that goes up to about 15 thousand plus rows (has the potential to go up to 30-50 thousand rows in a few years time).

My client does NOT want any paging, does not want any data cropped as well. Also he isn't exactly using the latest hardware so rendering on browsers is a big issue. He wants to view everything by printing it out or looking through it on the browser. (You may all think how insane that sounds, and it sure is).

Now I want to resolve this issue by rendering html quickly. At the moment its a simple asp.net grid view w/o paging. That essentially renders HTML tables. My options that I think are: - Manually rendering html using div (for quick loading) - export it to pdf or excel (is there any way to export without the need to resort to third party controls?) - give the finger (to the client :D j/k)

So to sum up, whats the best way to show 10,000 plus records of data on html?

Answer 1

consider using the "Scroller" plug-in for Datatables..

As part of DataTables 1.8 release a new plug-in called "Scroller" was introduced as part of the download package. Scroller is an implementation of virtual scrolling for DataTables, which presents a vertically scrolling table, scrolling the full height of the table, but drawing only the rows which are necessary for the visible display, leading to a huge performance increase. This is quite an exciting plug-in for DataTables not only for the performance increase, but also because it effectively provide a new user interaction with the table, allowing full scrolling of very large data sets.

Answer 2

I know this is almost a year late, but in case it helps someone.

Use SlickGrid - It uses divs instead of tables, which gives so much more performance in IE. Check this example