User issues and pull requests page is slow #12368

Open
opened 2025-11-02 10:07:28 -06:00 by GiteaMirror · 7 comments
Owner

Originally created by @yp05327 on GitHub (Jan 22, 2024).

Description

These two pages are very slow
https://gitea.com/issues
https://gitea.com/pulls

image
image

Other pages:
image

Not sure whether this is caused by network or something else.
After several times refresh the page, it seems correct.
image

Gitea Version

gitea.com

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?

gitea.com

Database

None

Originally created by @yp05327 on GitHub (Jan 22, 2024). ### Description These two pages are very slow https://gitea.com/issues https://gitea.com/pulls ![image](https://github.com/go-gitea/gitea/assets/18380374/70f6fcba-e850-41a9-a205-77af75470033) ![image](https://github.com/go-gitea/gitea/assets/18380374/11c6dc96-c213-4e04-875a-f961263a5850) Other pages: ![image](https://github.com/go-gitea/gitea/assets/18380374/8b4d9fea-620f-48b1-afed-b65f935cb98d) Not sure whether this is caused by network or something else. After several times refresh the page, it seems correct. ![image](https://github.com/go-gitea/gitea/assets/18380374/f27ac76e-d6f2-4040-88ce-77a49f528fe2) ### Gitea Version gitea.com ### 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? gitea.com ### Database None
Author
Owner

@yp05327 commented on GitHub (Feb 1, 2024):

Organization Dashboard is also very slow. I created a new one, and it took very very very long time to load the page.
image

@yp05327 commented on GitHub (Feb 1, 2024): Organization Dashboard is also very slow. I created a new one, and it took very very very long time to load the page. ![image](https://github.com/go-gitea/gitea/assets/18380374/ddc8caff-0e16-442c-82cc-f9396d9620bb)
Author
Owner

@lunny commented on GitHub (Feb 1, 2024):

Let's expect #29006 will resolve the problem.

@lunny commented on GitHub (Feb 1, 2024): Let's expect #29006 will resolve the problem.
Author
Owner

@42wim commented on GitHub (Feb 1, 2024):

@lunny The pulls/issues and milestones seem to use other code than the GetFeeds call that's optimized ?
I'm running locally with the mysql hint enabled and it's fast here especially the dashboard

@42wim commented on GitHub (Feb 1, 2024): @lunny The pulls/issues and milestones seem to use other code than the GetFeeds call that's optimized ? I'm running locally with the mysql hint enabled and it's fast here especially the dashboard
Author
Owner

@lunny commented on GitHub (Feb 2, 2024):

Wow, I'm confused. And I also sent #29010 to reduce database queries.

@lunny commented on GitHub (Feb 2, 2024): Wow, I'm confused. And I also sent #29010 to reduce database queries.
Author
Owner

@yp05327 commented on GitHub (Feb 9, 2024):

https://github.com/go-gitea/gitea/issues/28892#issuecomment-1920361836
This has been fix by the revert. It is really fast now.
image

@yp05327 commented on GitHub (Feb 9, 2024): https://github.com/go-gitea/gitea/issues/28892#issuecomment-1920361836 This has been fix by the revert. It is really fast now. ![image](https://github.com/go-gitea/gitea/assets/18380374/c40a56fd-c8ae-422d-8b6e-3e0c211206ee)
Author
Owner

@amix307 commented on GitHub (Feb 26, 2024):

Can you describe the fixing process in a little more detail?

@amix307 commented on GitHub (Feb 26, 2024): Can you describe the fixing process in a little more detail?
Author
Owner

@lunny commented on GitHub (Feb 26, 2024):

see https://github.com/go-gitea/gitea/issues/28892#issuecomment-1920422732

@lunny commented on GitHub (Feb 26, 2024): see https://github.com/go-gitea/gitea/issues/28892#issuecomment-1920422732
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#12368