How a query optimization gave birth to Infinite scroll @hnasr
How a query optimization gave birth to Infinite scroll  @hnasr
Uploaded July 2026 | Updated November 2026, 1 day ago
The infinite scroll in social media as we know it today is despised by all. But it didn't always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering.

0:00 Intro
1:00 Classic Paged results
6:23 Limitations of paging
9:00 The scroll interface
12:00 How TikTok to infinite scroll
14:00 The current state


Intermediate and Advanced Backend Engineering Course Bundle
courses.husseinnasser.com/bundle

My Book, Root Cause: Stories and Lessons from Two Decades of Backend Engineering Bugs
amzn.to/4cKfZhe

Backend, Database, OS Courses
courses.husseinnasser.com

Fundamentals of Database Engineering
database.husseinnasser.com

Fundamentals of Operating Systems Course
https://oscourse.win

NodeJS Internals and Architecture
https://node.win

Fundamentals of Backend Engineering
https://backend.win

Follow me on Substack
hnasr.substack.com

Members Only Content
youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg

Become a Member on YouTube
youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

Stay Awesome,
Hussein
How a query optimization gave birth to Infinite scrollSystem calls need a context switchCan NGINX fix this?All Postgres Locks Explained | A Deep DiveNew course alert - Unlocking Backend PerformanceWhat threads get from their processGitHub SSH key is Leaked - How bad is this?Does discipline work?Cloudflare Open sources Pingora (NGINX replacement)The only abstraction Im ok with, probablyOffloading CPU Intensive to threadsTLS done in the NIC?
Hussein Nasser |

How a query optimization gave birth to Infinite scroll

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER