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.

Sign up for GitHub

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

Jump to bottom

perf(DB Schema) Refactor DB Schema #6

Open
1 task
CaiusDai opened this issue Apr 5, 2023 · 0 comments
Open
1 task

perf(DB Schema) Refactor DB Schema #6

CaiusDai opened this issue Apr 5, 2023 · 0 comments
Labels
back_end Relating to back-end issues enhancement New feature or request

Comments

@CaiusDai
Copy link
Owner

CaiusDai commented Apr 5, 2023

Expectation

Some performance issues are noticed relating to DB schema. Refactoring the schema will improve the query performance.

Improvements

  • Use another table PostMetrics to store statistics of posts (e.g.: num_like), so we don't need to update the large table.

Note：

Anyone who is working on this issue should also modify the relating DB scripts and the queries.
@CaiusDai CaiusDai added back_end Relating to back-end issues enhancement New feature or request labels Apr 5, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
back_end Relating to back-end issues enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@CaiusDai