Database schema changes
还没有人认领这个 Issue。
评估
调研方向
Start with docs/setup.sql and reproduce the reported SELECT against a large items table to understand the current schema and query cost. Review the feeds, items, and subscriptions definitions, then trace the application code that uses feedUrl; done means the integer feedId migration and related queries remain synchronized across all three tables.
由索引模型根据 Issue 内容生成。
描述
Seeing that a database with millions of rows in the items table, can get queries to slow down, specifically this one:
SELECT * FROM items WHERE flDeleted = FALSE AND feedUrl IN (SELECT feedUrl FROM subscriptions WHERE listName='dave') ORDER BY pubDate DESC LIMIT 175;
Which can take ~10 seconds to load, I propose we switch from using feedUrl as the primary key to an integer based key, which will help speed up the query significantly. Testing locally, the same query took about ~20ms after the switch.
Maybe for such a big change, we might as well review the setup.sql file. The following tables use feedUrl as primary key and should be changed:
- feeds
- items
- subscriptions
But this will also involve code changes to keep in sync the new feedId with the current feedUrl and querying feedId instead.
- 主要语言
- HTML
- 星标
- 11
- 派生
- 4
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
scripting/feedlandInstall 的其他 Issue
-
难度 4/5 3-5 天 新手友好度 55/100
scripting/feedlandInstall#79 · 1 条评论 · 1 个 reaction ·
-
难度 2/5 1-3 小时 新手友好度 55/100
scripting/feedlandInstall#77 · 3 条评论 ·
-
难度 4/5 3-5 天 新手友好度 35/100
scripting/feedlandInstall#76 · 3 条评论 ·
-
难度 1/5 1 小时以内 新手友好度 20/100
scripting/feedlandInstall#74 · 3 条评论 ·
-
难度 4/5 3-5 天 新手友好度 20/100
scripting/feedlandInstall#73 · 1 条评论 ·
查看 scripting/feedlandInstall 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 85/100
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 86/100
FuRongJun-1999/dsh-memory#65 ·
维护者通常 1 天内回复
-
bug
难度 2/5 1-3 小时 新手友好度 68/100
hexlet-codebattle/codebattle#2361 ·
-
bug
难度 2/5 1-3 小时 新手友好度 78/100
Qiskit/qiskit-aer#2466 ·
-
难度 2/5 1-3 小时 新手友好度 85/100
维护者通常 1 天内回复