How a query optimization gave birth to infinite scroll
The Backend Engineering Show with Hussein Nasser

How a query optimization gave birth to infinite scroll

B1中级2026年7月10日21分钟

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

播放本集

打开播放器:完整文字稿,每个单词都可点击,附翻译和单词卡。

试一试:点任意单词

来自本集开头的真实句子,每个单词都标出了难度级别。

第 1 句,共 12 句 · 0:00

.

And I'm using the word ideal because I don't have any other adjectives that are not depressing.

点一个单词,用你的语言查看释义。

这些单词你认识吗?

本集中 8 个较难的单词。点一个查看释义,然后标记一下。

标记几个单词,我们会告诉你这一集是否适合你的水平。

这一集适合你吗?

B1

B1 · 中级

能听懂简单新闻就可以

A1 18%A2 15%B1 8%B2 45%C1 13%
  • 41% 的单词在 B1 或更简单的水平。
  • 每分钟 137 词:自然语速。
  • 整集共有 64 个较难的单词(B2 及以上)。

文字稿

本集开头部分。完整文字稿在播放器中。

0:00

I think we can all agree that the current state of social media consumption is far from ideal. And I'm using the word ideal because I don't have any other adjectives that are not depressing. You see, no one, and I can, I think, safely say no one, goes into any of these social media, tiktok or instagram or youtube shorts and goes out of that session

0:36

if they ever get out because believe it or not the companies behind that will do everything they can through algorithms and and then studying of the human psychology to keep you scrolling right and if you ever ever get out of that session you're freed rarely that you either feel feel good about it or talk about it or there's nothing prideful about

1:14

it there's absolutely zero value even if you learn something or you learned an idea or something it feels i don't know hello but i don't want to make this video depressing because everybody knows the current state of social media i want to talk about that that idea of infinite scroll didn't always started as an infinite scroll it actually started as a solution to a

以上是开头部分。 本集其余部分(19 分钟)在播放器中:每个单词都可点击,附翻译、生词收藏和单词卡。

在播放器中继续

由音频自动生成,可能存在错误。 音频版权归其发布者所有,并从其订阅源播放。版权所有者可申请删除 — 版权与删除政策