|
|
|
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? |
|