Release page loads slow with a lot of tags #165

Closed
opened 2025-11-02 03:11:36 -06:00 by GiteaMirror · 13 comments
Owner

Originally created by @deanpcmad on GitHub (Dec 26, 2016).

Originally assigned to: @lunny on GitHub.

Copied from https://github.com/gogits/gogs/issues/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

Originally created by @deanpcmad on GitHub (Dec 26, 2016). Originally assigned to: @lunny on GitHub. Copied from https://github.com/gogits/gogs/issues/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
GiteaMirror added the type/bug label 2025-11-02 03:11:36 -06:00
Author
Owner

@bkcsoft commented on GitHub (Dec 28, 2016):

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 commented on GitHub (Dec 28, 2016): 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
Author
Owner

@bkcsoft commented on GitHub (Dec 28, 2016):

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 :)

@bkcsoft commented on GitHub (Dec 28, 2016): 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 :)
Author
Owner

@deanpcmad commented on GitHub (Dec 28, 2016):

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

@deanpcmad commented on GitHub (Dec 28, 2016): Yeah I saw there is pagination so I did wonder why it was slow, that explains it :)
Author
Owner

@JetpackDuba commented on GitHub (Dec 28, 2016):

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

@JetpackDuba commented on GitHub (Dec 28, 2016): Will you fix it for 1.0.1 or only 1.1? Imo it should be in both :P
Author
Owner

@lunny commented on GitHub (Dec 31, 2016):

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

@lunny commented on GitHub (Dec 31, 2016): @deanpcmad, could you please test if #527 resolved your problem since I think there are also some improvements should be taken in future.
Author
Owner

@deanpcmad commented on GitHub (Dec 31, 2016):

@lunny sure, is there a build for it?

@deanpcmad commented on GitHub (Dec 31, 2016): @lunny sure, is there a build for it?
Author
Owner

@lunny commented on GitHub (Dec 31, 2016):

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

@lunny commented on GitHub (Dec 31, 2016): https://dl.gitea.io/gitea/master/, you can find your proper version.
Author
Owner

@JetpackDuba commented on GitHub (Jan 3, 2017):

I'm not who opened the issue but in my case using Windows 10 and MSSQL, I've cloned VS CODE github repo and tags page takes 8.8 seconds to load :S

@JetpackDuba commented on GitHub (Jan 3, 2017): I'm not who opened the issue but in my case using Windows 10 and MSSQL, I've cloned VS CODE github repo and tags page takes 8.8 seconds to load :S
Author
Owner

@deanpcmad commented on GitHub (Jan 3, 2017):

Hey, I've just tried it (version 09dabe2) but it is still very slow to load the tags page. If you want to test it yourself locally, mirror the https://github.com/rails/rails repo

@deanpcmad commented on GitHub (Jan 3, 2017): Hey, I've just tried it (version 09dabe2) but it is still very slow to load the tags page. If you want to test it yourself locally, mirror the https://github.com/rails/rails repo
Author
Owner

@JetpackDuba commented on GitHub (Jan 8, 2017):

Now it loads in 1sec! That's better!

@JetpackDuba commented on GitHub (Jan 8, 2017): Now it loads in 1sec! That's better!
Author
Owner

@lunny commented on GitHub (Jan 8, 2017):

Yes. But it's not perfect. It needs further improvement later.

@lunny commented on GitHub (Jan 8, 2017): Yes. But it's not perfect. It needs further improvement later.
Author
Owner

@lunny commented on GitHub (Jan 14, 2017):

On macOS and sqlite, rails still spent 10s.

@lunny commented on GitHub (Jan 14, 2017): On macOS and sqlite, rails still spent 10s.
Author
Owner

@lunny commented on GitHub (Nov 1, 2017):

https://try.gitea.io/lunny/rails/releases. v1.2+ have resolve this issue entirely.

@lunny commented on GitHub (Nov 1, 2017): https://try.gitea.io/lunny/rails/releases. v1.2+ have resolve this issue entirely.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#165