Hacker News new | ask | show | jobs
by cheschire 2621 days ago
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.

https://blog.jooq.org/2013/10/26/faster-sql-paging-with-jooq...