Milan Jovanović (@mjovanovictech) 's Twitter Profile
Milan Jovanović

@mjovanovictech

Practical .NET and Software Architecture Tips | Microsoft MVP

📰 The .NET Weekly: bit.ly/45T0U7i

▶️ YouTube: youtube.com/@MilanJovanovi…

ID: 1541479855660961792

linkhttps://bit.ly/45T0U7i calendar_today27-06-2022 17:54:38

15,15K Tweet

40,40K Followers

725 Following

Milan Jovanović (@mjovanovictech) 's Twitter Profile Photo
Milan Jovanović
@mjovanovictech

a month ago

Why OFFSET pagination slows down over time: - DB must scan all skipped rows - OFFSET 10000 means scan 10k, discard, return the rest - It doesn’t scale with large datasets