Slow response on repo/search

[richardbeumer]

Description

After updating Gitea from version 1.21.5 to 1.21.10 performance of repository search is much slower as before. Repo search was near instant and now taking up around 8 seconds.

We are using Elastic as repo indexer.

Logs show:

2024/04/23 12:40:42 ...eb/routing/logger.go:68:func1() [W] router: slow      GET /repo/search?sort=updated&order=desc&uid=11&team_id=undefined&q=bgt&page=1&limit=15&mode=&archived=false for 10.244.2.12:44360, elapsed 3301.6ms @ repo/repo.go:507(repo.SearchRepo)
2024/04/23 12:40:42 ...eb/routing/logger.go:102:func1() [I] router: completed GET /metrics for 10.244.4.12:50702, 200 OK in 220.7ms @ web/metrics.go:16(web.Metrics)

Screenshots

Gitea Version

1.21.10

Can you reproduce the bug on the Gitea demo site?

No

Operating System

kubernetes/container image

Browser Version

Chrome 124 / Firefox 125

[lunny]

The repository name search on dashboard just a database like operation. It's weird.

[richardbeumer]

I will have a look at our database then. Strange thing is that most search queries give a good response where other queries are slow.

[lunny]

What type database are you using with Gitea?

[richardbeumer]

We are running on Postgres.

[alvonwong]

I have the same problem . 1.21.5 works fine on FreeBSD14.1release/amd64/postgresql15，but 1.21.6 shows slow router and can't edit with sqlite or postgresql .
FYI, v1.21.11 and v1.22.0 work fine on FreeBSD14.1release/amd64/postgresql15 .