Why is logging in to the try.gitea.io homepage very slow

[tyroneyeh]

Description

as title

Gitea Version

1.18.0+dev-33-g97bfabc74

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

Git Version

No response

Operating System

No response

How are you running Gitea?

In try.gitea.io

Database

No response

[devgogo]

yes, very low.

[lunny]

Sometimes CPU is 100% and this is a single core VPS. And I haven't found why CPU is 100% sometimes.

[tyroneyeh]

Strange, the home page will get stuck after logging in. If I log in to explore, it's fine, but I can't go to the home page.

[zeripath]

Unfortunately it appears that the new indexes on the action table are bad for big SQLite DBs.

I've been able to correctly ascertain what they should be and will make a PR as soon as I have checked them on MySQL and other dbs.