Recommend A Solution For Large HTML Data Tables?

html table million rows
responsive table columns to rows
datatables
improve html table rendering performance
html table with 100000 rows
create large html table
jquery datatables load large data
javascript large table performance

I'm renovating a legacy Java webapp. I redid a screen that displays the results of a database search. The search can potentially produce a large number of results. The legacy version just printed everything. I went one better by putting in some divs and CSS such that horizontal and vertical scrollbars appear when needed.

This is not so great. The user loses sight of the column headers when scrolling vertically through many rows. Putting the column headers in their own div is not a great solution, as there are JUST ENOUGH columns to require horizontal scrolling too. The user would get stuck scrolling the results vertically and then scrolling the column names horizontally.

Would anyone care to recommend a solution that will not involve spending money or involve learning a whole new framework or system?

I don't need something high powered. Like I wrote, if the number of columns were just 2-3 fewer I probably wouldn't need horizontal scrolling and could just put the headers in their own stationary div.

I use datatables to display tables. It is some jquery that turns plane tables into sortable, searchable nicely looking tables.

http://datatables.net/

Displaying a Big HTML Table, How do I make a table row responsive in HTML? I found 5 common solutions to handle data tables on wide screens such as smartphones or tablets in vertical mode. You can use it immediately in your daily work as a designer — let’s go!

Why not repeat the column headers say every 20 rows so when the headers have scrolled off the screen you have them further down to. This could be done in your server side script.

Organizing Data with Tables, What are the elements to help organize the data and structure of a table? I can see it not being a good solution for pure data tables (eg. many columns of numeric data). Check out a Codepen implementation here. This solution was built on top of jQuery. TL;DR the Codepen: Format your table nicely (table>thead>tr>td^^tbody>tr>td) Copy the function.

You should be using paging in your query. For example when fetching page 7 and page size is 10, only record number 61 to 70 must be fetched from database.

Responsive Data Tables: A Comprehensive List of Solutions , Responsive Data Tables: A Comprehensive List of Solutions Tables are an important part of HTML. developer and an enthusiast writer for some of the largest web development magazines in the world (SitePoint, Tuts+). The Data Tables jQuery plugin adds all kinds of useful functionality to standard HTML tables. And its responsive abilities are quite amazing. The script will automatically hide columns based upon screen size. The hidden data is available for viewing with a click (or touch). You also have the flexibility to give priority to specific columns. The example below shows a responsive table in all its glory. Choosing the Best Technique

One easy way to go is to just repeat headers periodically. The code below shows how to do it, no libraries required. The sample builds a sample huge table (100 columns, 100 rows) and then just clones the header row every 10 rows.

const COLS = 100;
const ROWS = 100;
const HEADER_PERIOD = 10;

const table = document.querySelector("table");

// prepare header template
const header = document.createElement("tr");
header.classList.add("header");
for (let i = 0; i < COLS; i++) {
    const cell = header.insertCell();
    cell.innerText = String.fromCharCode(65 + Math.floor(Math.random() * 26));
}

// make some random rows and columns
for (let j = 0; j < ROWS; j++) {

    // repeat header row periodically so user doesn't get lost
    if (j % HEADER_PERIOD === 0) {
        table.appendChild(header.cloneNode(true));
    }

    const row = table.insertRow();
    for (let i = 0; i < COLS; i++) {
        const cell = row.insertCell();
        cell.innerText = Math.trunc(10 + Math.random() * 90).toFixed();
    }
}
body {
    font-family: monospace, sans-serif;
}
table {
    border-collapse: collapse;
}
th, td {
    padding: 2px;
    border: 1px solid;
    margin: 0;
}
.header {
    background-color: #ccc;
    text-align: center;
    font-weight: bold;
}
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Large table</title>
</head>
<body>

<table>
</table>

</body>
</html>

5 Practical Solutions to Make Responsive Data Tables, I found 5 common solutions to handle data tables on wide screens such as for wide tables (3–8 columns); for short tables (recommend to keep all height not for large amounts of content; the legend is not visible after scroll  There are two options that can be utilized to initialize data-table:-1) Add records as a html table on page and then initialize datatable on that table. 2) Have a json of records and then initialize datatable with that data. Do the following steps helps us to improve the performance of datatable plugin:-

Organizing Data with Tables, How a table should be built in HTML depends largely on the data and how it is to Borders around a table or individual cells can make a large impact when a  The key essence of a complex table is being large, thus giving the bird-eye view of data. Unfortunately, I cannot recall a really good method of using large tables on smartphone screens. Excel and Google spreadsheets lose their power on small screens, although there are effective ways to handle tiny tables.

Responsive Data Tables, We'll explore a CSS-based possible-solution to this issue. This is just one potential solution to the problem to data tables on small screens. It's not perfect. Isn't this as big a sin as adding style to your HTML? I'd recommend using the axis attribute since that's supposed to define to which headers a cell's data belongs. A table is a structured set of data made up of rows and columns (tabular data). A table allows you to quickly and easily look up values that indicate some kind of connection between different types of data, for example a person and their age, or a day of the week, or the timetable for a local swimming pool.

Accessible, Simple, Responsive Tables, I'm working on a website that has a lot of technical data and has thousands of hard coded wide html tables. The solution I used was the first non-recommended​  Grouping and sorting in tables are convenience options that make the analysis of the data easier to achieve using a single table, but are still secondary to the primary function of comparison. Lists are usually better suited to displaying a set of data for the purpose of locating one or more items of interest based on a few key characteristics.

Comments
  • Check out: stackoverflow.com/questions/1030043/…