[Summary] Loading user dashboard too slow

[yp05327]

Feature Description

We have received may reports about loading user dashboard too slow.
Please discuss/report related/similar issues (only the user dashboard, other pages are fine) in this summary, and avoid creating more and more.
Although these reports maybe caused by different reasons, I think it is better to have a summary about this issue.
@lunny
Can you pin this issue on the top?

Opening:

• Index page incredibly slow after update to 1.21.8 #29769
• Horrible Dashboard Delay After Upgrade #32224

Closed:

• Wrongly used index slows down queries on action table (dashboard view) #16665
• Heatmap data needs to be optimized #21045
• User dashboard takes a long time to load since 1.17 #21611
• In users' dashboard, it's very slow to load action. #23101
• Index page Very Slow SQL Query #31582
• When after login visit startpage( / ), loading long time #31646
• Index Page Incredibly Slow to Load - Slow SQL Query #32112

Screenshots

No response

[lunny]

#32110 should resolve the problem.

[yp05327]

Hope it works.

[lunny]

#32127 should resolve the problem for most Gitea instances.

[yp05327]

Still got report after upgrade to the latest version.