Have you found a solution? I have to paginate over 2.5m rows, and am
having the same issue.
The root of the issue is the SQL query runs a LIMIT offset, per_page, which
isn't efficient in large tables.
I'm considering writing in a flag to grab the ids of the rows, then
selecting the rows individually. However, I'm hoping somebody else has
solved pagination over large data sets. I can't be the first to run in