And have those rows be sortable by columns but not just for the current page but for the entire table.
@nerves – Sure. What you could do is throw all of the data into a MySQL database, and then have some pages that would display the data in a table with 50 (or however many) rows per page. Clicking on a column header would sort the table by that column.