[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
• Slow loading of dashboard view #32858

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
• Horrible Dashboard Delay After Upgrade #32224

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.

[lunny]

I think we can close this one and leave #29769 open.

[uxbug]

update 1.23.3 home page also too slow

• docker install
• database: sqlite
• git version 2.47.2
• Gitea version: 1.23.3 built with GNU Make 4.4.1, go1.23.6 : bindata, timetzdata, sqlite, sqlite_unlock_notify
• log

2025/02/13 07:29:03 ...s/graceful/server.go:50:NewServer() [I] Starting new Web server: tcp:0.0.0.0:3000 on PID: 18

2025/02/13 07:29:15 ...eb/routing/logger.go:68:func1() [W] router: slow      GET / for 1x.1x.x.x3:0, elapsed 3424.7ms @ web/home.go:32(web.Home)

2025/02/13 07:30:49 models/db/list.go:210:]() [W] [Slow SQL Query] SELECT `id`, `repo_id`, `schedule_id`, `next`, `prev`, `spec`, `created`, `updated` FROM `action_schedule_spec` WHERE next<=? ORDER BY `id` DESC LIMIT 50 [1739431803] - 46.067580691s

2025/02/13 07:30:49 ...eb/routing/logger.go:102:func1() [I] router: completed GET / for 1x.1x.x.x3:0, 200 OK in 97507.5ms @ web/home.go:32(web.Home)

2025/02/13 07:30:49 ...eb/routing/logger.go:102:func1() [I] router: completed GET /repo/search?count_only=1&uid=1&team_id=undefined&q=&page=1&mode= for 1x.1x.x.x3:0, 200 OK in 46.7ms @ repo/repo.go:573(repo.SearchRepo)

2025/02/13 07:30:50 ...eb/routing/logger.go:102:func1() [I] router: completed GET /repo/search?sort=updated&order=desc&uid=1&team_id=undefined&q=&page=1&limit=15&mode=&archived=false for 1x.1x.x.x3:0, 200 OK in 693.8ms @ repo/repo.go:573(repo.SearchRepo)

• doctor check result

9a8546a05926:~$ gitea doctor check --run check-db-consistency

[1] Check consistency of database
OK

All done (checks: 1).