Pagination with search

The datatables I have seen load all the records into the HTML contents, then use JS to limit the display. With millions of records, that would be really slow to load, and the js might be very slow to sort so many too. I imagine the right way to do it would be to use ajax for pagination and sorting, collecting fresh limited data lists as an when requested, although to be fair, I have not done this for data tables, and if I did I would probably just write my own js to do the job and not use a datatables library of any sort.

PS I started using Microsoft Edge recently (Firefox always seems to slow over time and Chrome annoys me now). I must say, it is not like the IE family of old. A few sites have peculiarities, like CI Forum code tags do not wrap around selected text, but apart from a few vagaries, it is really slick, fast, and I do like the UI for laying aside tabs, bookmarks and reading modes.