starman@programming.dev to Programming@programming.devEnglish · edit-211 months agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square17fedilinkarrow-up115arrow-down118file-text
arrow-up1-3arrow-down1external-linkWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netstarman@programming.dev to Programming@programming.devEnglish · edit-211 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·11 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.