starman@programming.dev to Programming@programming.devEnglish · edit-27 months agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square17fedilinkarrow-up115arrow-down117file-text
arrow-up1-2arrow-down1external-linkWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netstarman@programming.dev to Programming@programming.devEnglish · edit-27 months agomessage-square17fedilinkfile-text
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
minus-squareMax-P@lemmy.max-p.melinkfedilinkarrow-up6·7 months agoLemmy just implemented it for 0.19 and it makes a big difference on heavier queries like Scaled homepage. It also has the advantage of your pagination not getting screwy if new content has been added between page 2 and 3 queries.
Lemmy just implemented it for 0.19 and it makes a big difference on heavier queries like Scaled homepage.
It also has the advantage of your pagination not getting screwy if new content has been added between page 2 and 3 queries.