starman@programming.dev to Programming@programming.devEnglish · edit-21 year agoWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netexternal-linkmessage-square8fedilinkarrow-up110arrow-down12file-text
arrow-up18arrow-down1external-linkWhy You Shouldn’t Use OFFSET and LIMIT For Your Paginationivopereira.netstarman@programming.dev to Programming@programming.devEnglish · edit-21 year agomessage-square8fedilinkfile-text
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
minus-squareYodaDaCodalinkfedilinkEnglisharrow-up2·1 year agoOh thanks mate 👍 Interesting article but I kinda fail to see how you’d go if your paginating through sorted rows - you’d have to have an id in the sequence of your sort order?
Oh thanks mate 👍
Interesting article but I kinda fail to see how you’d go if your paginating through sorted rows - you’d have to have an id in the sequence of your sort order?