Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature]: 数据库导入的sql文件添加索引优化 || [Feature]: Add index optimization to the sql file imported from the database #2665

Open
axiaoxin opened this issue Aug 13, 2024 · 1 comment
Labels
discussion Question or dicussion enhancement New feature or request Inactive

Comments

@axiaoxin
Copy link

axiaoxin commented Aug 13, 2024

功能概述 | Describe the feature

看了一下日志,有很多查询貌似都没有索引。
数据量大了以后性能会有影响,计数表和评论表里面url字段可以加前缀索引,或者做成固定长度的hash然后见唯一索引(需要改代码逻辑)


Feature Overview | Describe the feature

After looking at the logs, it seems that many queries are not indexed.
Performance will be affected when the amount of data is large. The URL field in the count table and comment table can be added with a prefix index, or it can be made into a fixed-length hash and then used as a unique index (the code logic needs to be changed)

@axiaoxin axiaoxin added discussion Question or dicussion enhancement New feature or request labels Aug 13, 2024
@github-actions github-actions bot changed the title [Feature]: 数据库导入的sql文件添加索引优化 [Feature]: 数据库导入的sql文件添加索引优化 || [Feature]: Add index optimization to the sql file imported from the database Aug 13, 2024
@lizheming
Copy link
Collaborator

lizheming commented Aug 23, 2024

是个不错的建议,也欢迎 PR 呀~


This is a good suggestion, PR is also welcome~

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
discussion Question or dicussion enhancement New feature or request Inactive
Projects
None yet
Development

No branches or pull requests

2 participants