Hacker News new | ask | show | jobs
This website is using pagination with OFFSET/LIMIT but it's fast
2 points by nij4uyr 2233 days ago
Hey guys,

First, here's the link

https://gall.dcinside.com/board/lists/?id=baseball_new8&page=270000

As you can see from the URL, it's specifying the page number. And as the characteristic of OFFSET pagination, the page result is unstable when new items are inserted (which is what I want)

I can't believe the performance cuz the website has > 16M records and still the performance is blazing fast.

What kind of sorcery pagination is that? anyone can guess?