I may be taking your post at face value, but I suggest if you are using skip, i.e. LINQ Skip(), that you stop. SQL's performance using OFFSET is pretty terrible when you start getting into the 10's of thousands of records. Instead, use seek instead.
Here's some random google result that talks about the concept. There are plenty out there though.
Here's some random google result that talks about the concept. There are plenty out there though.
https://blog.jooq.org/2013/10/26/faster-sql-paging-with-jooq...