Settings

Theme

This website is using pagination with OFFSET/LIMIT but it's fast

2 points by nij4uyr 6 years ago · 0 comments · 1 min read

Reader

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?

No comments yet.

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection