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

Use db.ListOptions directly instead of Paginator interface to make it easier to use and fix performance of /pulls and /issues #29990

Merged
merged 12 commits into from Mar 24, 2024

Conversation

lunny
Copy link
Member

@lunny lunny commented Mar 22, 2024

This PR uses db.ListOptions instead of Paginor to make the code simpler.
And it also fixed the performance problem when viewing /pulls or /issues. Before the counting in fact will also do the search.

@lunny lunny added type/bug type/refactoring Existing code has been cleaned up. There should be no new functionality. labels Mar 22, 2024
@GiteaBot GiteaBot added the lgtm/need 2 This PR needs two approvals by maintainers to be considered for merging. label Mar 22, 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 22, 2024
@github-actions github-actions bot added modifies/api This PR adds API routes or modifies them modifies/go Pull requests that update Go code labels Mar 22, 2024
@pull-request-size pull-request-size bot added size/M Denotes a PR that changes 30-99 lines, ignoring generated files. and removed size/L Denotes a PR that changes 100-499 lines, ignoring generated files. labels Mar 22, 2024
@github-actions github-actions bot removed the modifies/api This PR adds API routes or modifies them label Mar 22, 2024
@wolfogre
Copy link
Member

wolfogre commented Mar 22, 2024

For f886a75: https://github.com/meilisearch/meilisearch/discussions/4527

@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 22, 2024
@lunny lunny added the backport/v1.21 This PR should be backported to Gitea 1.21 label Mar 22, 2024
@lunny lunny changed the title Use db.ListOptions directly instead of Paginator interface to make it easier to user Use db.ListOptions directly instead of Paginator interface to make it easier to use and fix performance of /pulls and /issues Mar 22, 2024
@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 24, 2024
@silverwind
Copy link
Member

No backport needed imho.

@6543 6543 removed the backport/v1.21 This PR should be backported to Gitea 1.21 label Mar 24, 2024
@6543 6543 enabled auto-merge (squash) March 24, 2024 18:17
@6543 6543 added the reviewed/wait-merge This pull request is part of the merge queue. It will be merged soon. label Mar 24, 2024
@6543 6543 merged commit 3f26fe2 into go-gitea:main Mar 24, 2024
26 checks passed
@GiteaBot GiteaBot added this to the 1.23.0 milestone Mar 24, 2024
@GiteaBot GiteaBot removed the reviewed/wait-merge This pull request is part of the merge queue. It will be merged soon. label Mar 24, 2024
@lunny lunny deleted the lunny/improve_pagnation branch March 25, 2024 01:37
@lunny
Copy link
Member Author

lunny commented Mar 25, 2024

No backport needed imho.

The performance of /pulls and /issues have been regression in v1.21. This PR will fix it. Maybe we can partially back port just for the performance.

@6543 6543 added the backport/v1.21 This PR should be backported to Gitea 1.21 label Mar 25, 2024
@GiteaBot
Copy link
Contributor

I was unable to create a backport for 1.21. @lunny, please send one manually. 🍵

go run ./contrib/backport 29990
...  // fix git conflicts if any
go run ./contrib/backport --continue

@GiteaBot GiteaBot added the backport/manual No power to the bots! Create your backport yourself! label Mar 25, 2024
silverwind added a commit to silverwind/gitea that referenced this pull request Mar 25, 2024
* origin/main:
  Remove fomantic table module (go-gitea#30047)
  Fix menu buttons in issues and release (go-gitea#30056)
  Fix git grep search limit, add test (go-gitea#30071)
  Fix button hover border (go-gitea#30048)
  Fix Add/Remove WIP on pull request title failure (go-gitea#29999)
  Fix misuse of `TxContext` (go-gitea#30061)
  Remove jQuery `.attr` from the reaction selector (go-gitea#30052)
  Remove jQuery `.attr` from the ComboMarkdownEditor (go-gitea#30051)
  Remove jQuery `.attr` from the label edit exclusive checkbox (go-gitea#30053)
  Remove jQuery `.attr` from the repository topic bar (go-gitea#30050)
  Use db.ListOptions directly instead of Paginator interface to make it easier to use and fix performance of /pulls and /issues (go-gitea#29990)
  Migrate `gt-hidden` to `tw-hidden` (go-gitea#30046)
  Forbid jQuery `is` and fix issues (go-gitea#30016)
  Remove fomantic segment module (go-gitea#30042)
  Migrate margin and padding helpers to tailwind (go-gitea#30043)
@lunny lunny modified the milestones: 1.23.0, 1.22.0 Mar 26, 2024
lunny added a commit to lunny/gitea that referenced this pull request Apr 12, 2024
… easier to use and fix performance of /pulls and /issues (go-gitea#29990)

This PR uses `db.ListOptions` instead of `Paginor` to make the code
simpler.
And it also fixed the performance problem when viewing /pulls or
/issues. Before the counting in fact will also do the search.

---------

Co-authored-by: Jason Song <i@wolfogre.com>
Co-authored-by: silverwind <me@silverwind.io>
@lunny lunny added the backport/done All backports for this PR have been created label Apr 12, 2024
silverwind added a commit that referenced this pull request Apr 13, 2024
…easier to use and fix performance of /pulls and /issues (#29990) (#30447)

backport #29990

This PR uses `db.ListOptions` instead of `Paginor` to make the code
simpler.
And it also fixed the performance problem when viewing /pulls or
/issues. Before the counting in fact will also do the search.

Co-authored-by: Jason Song <i@wolfogre.com>
Co-authored-by: silverwind <me@silverwind.io>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backport/done All backports for this PR have been created backport/manual No power to the bots! Create your backport yourself! backport/v1.21 This PR should be backported to Gitea 1.21 lgtm/done This PR has enough approvals to get merged. There are no important open reservations anymore. modifies/go Pull requests that update Go code size/M Denotes a PR that changes 30-99 lines, ignoring generated files. type/bug type/refactoring Existing code has been cleaned up. There should be no new functionality.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

5 participants