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

Closed
opened 2025-11-02 08:30:20 -06:00 by GiteaMirror · 4 comments
Owner

Originally created by @tyroneyeh on GitHub (Jun 25, 2022).

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

image

Git Version

No response

Operating System

No response

How are you running Gitea?

In try.gitea.io

Database

No response

Originally created by @tyroneyeh on GitHub (Jun 25, 2022). ### 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 <img width="521" alt="image" src="https://user-images.githubusercontent.com/1255041/175764043-4382c770-cac0-4a8f-9826-7a9466f72bc4.png"> ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? In try.gitea.io ### Database _No response_
GiteaMirror added the type/bug label 2025-11-02 08:30:20 -06:00
Author
Owner

@devgogo commented on GitHub (Jun 27, 2022):

yes, very low.

@devgogo commented on GitHub (Jun 27, 2022): yes, very low.
Author
Owner

@lunny commented on GitHub (Jun 27, 2022):

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

@lunny commented on GitHub (Jun 27, 2022): Sometimes CPU is 100% and this is a single core VPS. And I haven't found why CPU is 100% sometimes.
Author
Owner

@tyroneyeh commented on GitHub (Jun 27, 2022):

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.

@tyroneyeh commented on GitHub (Jun 27, 2022): 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.
Author
Owner

@zeripath commented on GitHub (Jun 27, 2022):

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.

@zeripath commented on GitHub (Jun 27, 2022): 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.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#9127