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-squareBlackmist@lemmy.worldlinkfedilinkEnglisharrow-up2·11 months agoWhich it almost never is. Any data as simple as that is unlikely to reach a number of rows likely to cause an issue with performance.
Which it almost never is.
Any data as simple as that is unlikely to reach a number of rows likely to cause an issue with performance.