What is the best performing way to have 2000 rows visible?

NielsRavn

We are making a large system where we have a table with 400.000 rows that are widely searchable
Our customer has specifically requested that they can have 2.000 rows loaded at a time, to scroll through it. im not realy sure how they keep track of where they are in that amount of data, but that is what they want.
We have made the solution with datatables and set it to load 2.000 rows with server side processing.

The rendering of this data i pretty slow and we would like to know what the best way is to make it render in a timely manner.

using scroller makes quite alot of requests, and we are interacting with the visible data ( select all, select specifics, etc.) so we would need some kind of "load all the data for one page(2.000 rows) and render only the visible rows.

For security reasons i cant give access to the page or a test server of the actual page. But i have made a mock up, which just gets random data, with the same amount of rows and columns, in the mockup i have stripped all other functionality and the load is still too slow.
datatabletest.ptast.dk/

The table is initialized with only the basics for making it run server side processing

var dataTable = $('.datatable').DataTable({
            lengthChange: true,
            lengthMenu: [[10, 25, 50, 100, 500, 1000, 2000], [10, 25, 50, 100, 500, 1000, 2000]],
            pageLength:  2000,
            processing: true,
            serverSide: true,
            "ajax": {
                "url": '/Home/GetData',
                "type": 'POST'
            }
        });

Thanks in advance
Niels Ravn
Software Developer at VeTech Software Solutions