Can javascript sort, filter and display a very large table?

Question

First of all, I have no idea about the possibility of Javascript. But I would like to know if this is possible:

• To read from a text file and display a very large table (a couple of tens of columns and several hundred thousand rows), in the sections:
• Not all columns will be displayed at the same time. columns are in groups. a group of columns should switch between hidden or show;
• Rows can be filtered based on specific columns.

The reason for this is the creation of a report that displays the results of data analysis, and also provides the basic filtering and sorting functions for the user. They will most likely have some kind of web browser. Thus, HTML will be an ideal format.

Is this possible with Javascript?

Thanks!

Answer 1

You may be able to do this using the grid plugin. For example, take a look at the answers to this question: JavaScript data table for millions of rows

Answer 2

I would recommend a javascript table library like DataTables. It includes sorting, filtering, and pagination options.

In addition, it has the functionality to cancel all the search calls, filtering, sorting, etc. that DataTables makes for the server. Javascript lib DataTables is just an event and display module. In this case, you can process any number of lines.

Thus, you will have all the necessary functionality, with ajax-y fast loading of data loaded into javascript using a scale to process any number of lines.

Server-side data processing with DataTables

Answer 3

Absolutely yes. Ext.JS shows how to do this very efficiently. When done correctly, this is a performance optimization that reduces rounding to the server. And improves UX responsiveness.

ExtJS Rich Grid example (there are many)

ExtJS examples (see grid section)

Hope this helps.