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

Do some performance optimize for issues list and view issue/pull #29515

Merged
merged 10 commits into from Mar 12, 2024

Conversation

lunny
Copy link
Member

@lunny lunny commented Mar 1, 2024

This PR do some performance optimzations.

  • Add index for the column comment_id of Attachment table to accelerate query from the database.
  • Remove unnecessary database queries when viewing issues. Before some conditions which id = 0 will be sent to the database
  • Remove duplicated load posters
  • Batch loading attachements, isread of comments on viewing issue

@GiteaBot GiteaBot added the lgtm/need 2 This PR needs two approvals by maintainers to be considered for merging. label Mar 1, 2024
@pull-request-size pull-request-size bot added the size/L Denotes a PR that changes 100-499 lines, ignoring generated files. label Mar 1, 2024
@github-actions github-actions bot added modifies/api This PR adds API routes or modifies them modifies/migrations labels Mar 1, 2024
@@ -323,10 +323,6 @@ func ListRepoIssueComments(ctx *context.APIContext) {
ctx.Error(http.StatusInternalServerError, "LoadIssues", err)
return
}
if err := comments.LoadPosters(ctx); err != nil {
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Remove duplicated load posters with line 316.

@lunny lunny added the performance/speed performance issues with slow downs label Mar 1, 2024
@GiteaBot GiteaBot added lgtm/need 1 This PR needs approval from one additional maintainer to be merged. and removed lgtm/need 2 This PR needs two approvals by maintainers to be considered for merging. labels Mar 8, 2024
routers/web/repo/issue.go Outdated Show resolved Hide resolved
@GiteaBot GiteaBot added lgtm/done This PR has enough approvals to get merged. There are no important open reservations anymore. and removed lgtm/need 1 This PR needs approval from one additional maintainer to be merged. labels Mar 12, 2024
Co-authored-by: Zettat123 <zettat123@gmail.com>
@lunny lunny added the reviewed/wait-merge This pull request is part of the merge queue. It will be merged soon. label Mar 12, 2024
@lunny lunny enabled auto-merge (squash) March 12, 2024 06:57
@lunny lunny merged commit d8bd6f3 into go-gitea:main Mar 12, 2024
26 checks passed
@GiteaBot GiteaBot added this to the 1.23.0 milestone Mar 12, 2024
@GiteaBot GiteaBot removed the reviewed/wait-merge This pull request is part of the merge queue. It will be merged soon. label Mar 12, 2024
zjjhot added a commit to zjjhot/gitea that referenced this pull request Mar 12, 2024
* upstream/main:
  Add more stats tables (go-gitea#29730)
  Use Get but not Post to get actions artifacts (go-gitea#29734)
  Do some performance optimize for issues list and view issue/pull (go-gitea#29515)
@lunny lunny modified the milestones: 1.23.0, 1.22.0 Mar 13, 2024
@lunny lunny deleted the lunny/optimaze_view_issue branch March 20, 2024 07:42
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
lgtm/done This PR has enough approvals to get merged. There are no important open reservations anymore. modifies/api This PR adds API routes or modifies them modifies/migrations performance/speed performance issues with slow downs size/L Denotes a PR that changes 100-499 lines, ignoring generated files.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

4 participants