Page on the client, really, even for 1M rows
Too often do we find ourselves clicking, and clicking, and clicking "Next" through trivial amounts of data--a few thousand rows--or fighting a search box that doesn't really work. Though the DOM genuinely doesn't seem to like tens of thousands of rows, a little virtualization (e.g., via the excellent DataTables library) goes a long way. If you're up for some DuckDB-Wasm fun, you can page through a million row just fine.
Obligatory demo below. (Demo vibe-coded, unlike this text.) Thanks, OpenStreetMap data.