github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-11 17:46:29 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

[performance] Listing repositories is slow #11364

New Issue
Closed
opened 2025-11-02 09:35:34 -06:00 by GiteaMirror · 6 comments
GiteaMirror commented 2025-11-02 09:35:34 -06:00
Owner
Copy Link

Originally created by @KazzmanK on GitHub (Jul 29, 2023).

Description

Request to
/repo/search?sort=updated&order=desc&uid=3&team_id=undefined&q=&page=1&limit=100&mode=&archived=false

on dashboard page (http://root_path), right pane, takes almost 5 seconds for 50 repositories exists

Database - sqlite

At the same time same repository list on http://root_path/organization appears instantly

Screenshots

none

Gitea Version

1.20.1

Can you reproduce the bug on the Gitea demo site?

No

Operating System

Windows server 10.0

Browser Version

113

Originally created by @KazzmanK on GitHub (Jul 29, 2023). ### Description Request to /repo/search?sort=updated&order=desc&uid=3&team_id=undefined&q=&page=1&limit=100&mode=&archived=false on dashboard page (http://root_path), right pane, takes almost 5 seconds for 50 repositories exists Database - sqlite At the same time same repository list on http://root_path/organization appears instantly ### Screenshots none ### Gitea Version 1.20.1 ### Can you reproduce the bug on the Gitea demo site? No ### Operating System Windows server 10.0 ### Browser Version 113
GiteaMirror added the performance/speedtopic/ui labels 2025-11-02 09:35:34 -06:00
GiteaMirror commented 2025-11-02 09:35:35 -06:00
Author
Owner
Copy Link

@KazzmanK commented on GitHub (Jul 29, 2023):

Oh, looks like for every repo 3 git commands are executed. Looks like information from database is not sufficient to display repo list. But in Json returned by rest method seems does not contains any special data.

@KazzmanK commented on GitHub (Jul 29, 2023): Oh, looks like for every repo 3 git commands are executed. Looks like information from database is not sufficient to display repo list. But in Json returned by rest method seems does not contains any special data.
GiteaMirror commented 2025-11-02 09:35:35 -06:00
Author
Owner
Copy Link

@KazzmanK commented on GitHub (Jul 29, 2023):

It is not clear, why here, in "https://root_path", after "SearchRepositoryByCondition" git commands are executed, but on "https://root_path/Organization" after the same "SearchRepositoryByCondition" - no git commands are executed and pageload is instant.

@KazzmanK commented on GitHub (Jul 29, 2023): It is not clear, why here, in "https://root_path", after "SearchRepositoryByCondition" git commands are executed, but on "https://root_path/Organization" after the same "SearchRepositoryByCondition" - no git commands are executed and pageload is instant.
GiteaMirror commented 2025-11-02 09:35:35 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Jul 30, 2023):

This issue comes from #24638 in v1.20 and should be resolved by #22743 in v1.21

@lunny commented on GitHub (Jul 30, 2023): This issue comes from #24638 in v1.20 and should be resolved by #22743 in v1.21
GiteaMirror commented 2025-11-02 09:35:36 -06:00
Author
Owner
Copy Link

@Sebazzz commented on GitHub (Sep 11, 2023):

Yes, I also ran into this after upgrading v1.19 to v1.20.4. Glad a fix is inbound!

@Sebazzz commented on GitHub (Sep 11, 2023): Yes, I also ran into this after upgrading v1.19 to v1.20.4. Glad a fix is inbound!
GiteaMirror commented 2025-11-02 09:35:36 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Dec 5, 2024):

I think this has been resolved. Please feel free to reopen if it is still a problem.

@lunny commented on GitHub (Dec 5, 2024): I think this has been resolved. Please feel free to reopen if it is still a problem.
GiteaMirror commented 2025-11-02 09:35:36 -06:00
Author
Owner
Copy Link

@Sebazzz commented on GitHub (Dec 5, 2024):

Yes, though also simply reorganizing indices in MSSQL also helped!

@Sebazzz commented on GitHub (Dec 5, 2024): Yes, though also simply reorganizing indices in MSSQL also helped!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label performance/speed topic/ui
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#11364
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?