Performance issue on pulls list API endpoint with lots of PR's #12841

New Issue

GiteaMirror · 2025-11-02T10:22:37-06:00

GiteaMirror commented

2025-11-02 10:22:37 -06:00

Originally created by @42wim on GitHub (Apr 14, 2024).

Description

We're running renovatebot and were getting timeouts (and renovatebot crashes) because the api/v1/repos/{owner}/{repo}/pulls?state=all endpoint is taking too long on repos with lots of PR's > 3k ( this takes almost 2 minutes, also the repo's are on NFS)

I've traced the issue to the ToAPIPullRequest function b84baf21fa/services/convert/pull.go (L23)

That function is doing git.OpenRepository a couple of times, which for > 3k pr's means it doing this ~ 10k times.
I'm not sure how to solve this, maybe it's possible to directly add extra keys to the PullRequest model so they don't need to be queried live or adding a separate cache for this ?

Gitea Version

1.21.10

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

Using gitea docker image

Database

MySQL/MariaDB

Originally created by @42wim on GitHub (Apr 14, 2024). ### Description We're running renovatebot and were getting timeouts (and renovatebot crashes) because the api/v1/repos/{owner}/{repo}/pulls?state=all endpoint is taking too long on repos with lots of PR's > 3k ( this takes almost 2 minutes, also the repo's are on NFS) I've traced the issue to the `ToAPIPullRequest` function https://github.com/go-gitea/gitea/blob/b84baf21fa19521e1ab303a60918c74f85fcad1c/services/convert/pull.go#L23 That function is doing `git.OpenRepository` a couple of times, which for > 3k pr's means it doing this ~ 10k times. I'm not sure how to solve this, maybe it's possible to directly add extra keys to the `PullRequest` model so they don't need to be queried live or adding a separate cache for this ? ### Gitea Version 1.21.10 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? Using gitea docker image ### Database MySQL/MariaDB

GiteaMirror added the performance/speed topic/api labels 2025-11-02 10:22:37 -06:00

GiteaMirror closed this issue

2025-11-02 10:22:37 -06:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#12841