Episode

How a query optimization gave birth to infinite scroll

Podcast: The Backend Engineering Show with Hussein Nasser
Published: Jul 10, 2026
Duration seconds: 1280
Processing state: not_requested
Canonical source: https://podcasters.spotify.com/pod/show/hnasr/episodes/How-a-query-optimization-gave-birth-to-infinite-scroll-e3lrc2n
Audio: https://anchor.fm/s/1eb6d14/podcast/play/122580503/https%3A%2F%2Fd3ctxlq1ktw2nl.cloudfront.net%2Fstaging%2F2026-6-8%2Fc5a227fe-ff9d-b173-da0c-d3892f83119d.m4a
JSON: /v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/how-a-query-optimization-gave-birth-to-infinite-scroll
Markdown: /podcast/the-backend-engineering-show-with-hussein-nasser-847440/how-a-query-optimization-gave-birth-to-infinite-scroll.md

Actions

POST https://stenobird.com/v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/how-a-query-optimization-gave-birth-to-infinite-scroll/transcription-requests
Idempotently request low-priority transcript generation for this episode.
GET https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/how-a-query-optimization-gave-birth-to-infinite-scroll.md
Read the agent-friendly Markdown representation of this episode resource.

Summary

The infinite scroll in social media as we know it today is despised by all. But it 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 Intro1:00 Classic Paged results 6:23 Limitations of paging9:00 The scroll interface 12:00 How TikTok to infinite scroll 14:00 The current state