Release page loads slow with a lot of tags

[deanpcmad]

Copied from gogs/gogs#3094

• Gitea version (or commit ref): 1.0
• Git version:
• Operating system:
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
  • Not relevant
• Log gist:

Description

I've just created a mirror repository for the rails repo and upon viewing the "Releases" tab, it takes forever to load, sometimes not loading at all which can cause nginx to timeout

Please see #491 as well

[bkcsoft]

not an enhancement, it's a bug. I added release pagniation a while back but I seem to have missed this for-loop here that still loop over all tags 😒 https://github.com/go-gitea/gitea/blob/master/routers/repo/release.go#L77

[bkcsoft]

Just flipping that for-loop around and using ctx.Repo.GitRepo.GetTag(r.TagName) should make it way faster, and TBH we probably don't need the caching anymore since we're not fetching all tags in one go :)

[deanpcmad]

Yeah I saw there is pagination so I did wonder why it was slow, that explains it :)

[JetpackDuba]

Will you fix it for 1.0.1 or only 1.1? Imo it should be in both :P

[lunny]

@deanpcmad, could you please test if #527 resolved your problem since I think there are also some improvements should be taken in future.

[deanpcmad]

@lunny sure, is there a build for it?

[lunny]

https://dl.gitea.io/gitea/master/, you can find your proper version.