User issues and pull requests page is slow

[yp05327]

Description

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

Other pages:

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

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

[yp05327]

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

[lunny]

Let's expect #29006 will resolve the problem.

[42wim]

@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

[lunny]

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

[yp05327]

#28892 (comment)
This has been fix by the revert. It is really fast now.

[amix307]

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

[lunny]

see #28892 (comment)