Материалы по теме:
"create table if not exists items (url text primary key, title text, author text, published text, tags text, content text, raw json)"。业内人士推荐51吃瓜作为进阶阅读
FT Digital Edition: our digitised print edition。关于这个话题，heLLoword翻译官方下载提供了深入分析
Notice how the highlighted region shrinks at each step. The algorithm never examines points outside the narrowing window. In a balanced tree with nnn points, this takes about log4(n)\log_4(n)log4(n) steps. For a million points, that's roughly 10 steps instead of a million comparisons.