Codeberg/Community
54
325
Fork
You've already forked Community
12

Notifications page slow #2016

Closed
opened 2025年07月08日 13:32:36 +02:00 by sclu1034 · 5 comments

Comment

https://codeberg.org/notifications is quite slow for me, at 1.5 to 2 seconds load time.

image

If it was only once for loading the view, that wouldn't be too much of an issue. But dismissing a notification actually does a 0.5 seconds POST to /status, and then reloads the page, so an average of 2 seconds wait time to dismiss a notification.

And this seems to be specific to Codeberg. On my personal instance, the page loads in less than 200 ms with a similar amount of notifications.

### Comment https://codeberg.org/notifications is quite slow for me, at 1.5 to 2 seconds load time. ![image](/attachments/501ac388-3678-4770-a2c0-4c619ad5e2c3) If it was only once for loading the view, that wouldn't be too much of an issue. But dismissing a notification actually does a 0.5 seconds POST to `/status`, and then reloads the page, so an average of 2 seconds wait time to dismiss a notification. And this seems to be specific to Codeberg. On my personal instance, the page loads in less than 200 ms with a similar amount of notifications.

and then reloads the page, so an average of 2 seconds wait time to dismiss a notification.

Can confirm.

> and then reloads the page, so an average of 2 seconds wait time to dismiss a notification. Can confirm.

Yes, this is somewhat expected. I do not think that the notifications table has good indexes to make this operation fast. I've already tried to remedy the situation in forgejo/forgejo#6146 - but it seems that the table and individual notifications have grown large enough for this to be a problem again. This is a scaling problem with Forgejo.

Yes, this is somewhat expected. I do not think that the notifications table has good indexes to make this operation fast. I've already tried to remedy the situation in forgejo/forgejo#6146 - but it seems that the table and individual notifications have grown large enough for this to be a problem again. This is a scaling problem with Forgejo.

I did some tracing and performance profiling and created a database index based on the slow SQL queries. For me it's currently quite responsive, please test this and check if it's also fast for you. @sclu1034 @n0toose

I did some tracing and performance profiling and created a database index based on the slow SQL queries. For me it's currently quite responsive, please test this and check if it's also fast for you. @sclu1034 @n0toose

To me it seems substantially faster than it used to be!

To me it seems substantially faster than it used to be!

Feels much better now.

Feels much better now.
Sign in to join this conversation.
No Branch/Tag specified
main
No results found.
Labels
Clear labels
accessibility

Reduces accessibility and is thus a "bug" for certain user groups on Codeberg.
bug

Something is not working the way it should. Does not concern outages.
bug
infrastructure

Errors evidently caused by infrastructure malfunctions or outages
Codeberg

This issue involves Codeberg's downstream modifications and settings and/or Codeberg's structures.
contributions welcome

Please join the discussion and consider contributing a PR!
docs

No bug, but an improvement to the docs or UI description will help
duplicate

This issue or pull request already exists
enhancement

New feature
infrastructure

Involves changes to the server setups, use `bug/infrastructure` for infrastructure-related user errors.
legal

An issue directly involving legal compliance
licence / ToS

involving questions about the ToS, especially licencing compliance
please chill
we are volunteers

Please consider editing your posts and remember that there is a human on the other side. We get that you are frustrated, but it's harder for us to help you this way.
public relations

Things related to Codeberg's external communication
question

More information is needed
question
user support

This issue contains a clearly stated problem. However, it is not clear whether we have to fix anything on Codeberg's end, but we're helping them fix it and/or find the cause.
s/Forgejo

Related to Forgejo. Please also check Forgejo's issue tracker.
s/Forgejo/migration

Migration related issues in Forgejo
s/Pages

Issues related to the Codeberg Pages feature
s/Weblate

Issue is related to the Weblate instance at https://translate.codeberg.org
s/Woodpecker

Woodpecker CI related issue
security

involves improvements to the sites security
service

Add a new service to the Codeberg ecosystem (instead of implementing into Gitea)
upstream

An open issue or pull request to an upstream repository to fix this issue (partially or completely) exists (i.e. Gitea, Forgejo, etc.)
wontfix

Codeberg's current set of contributors are not planning to spend time on delegating this issue.
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
4 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
Codeberg/Community#2016
Reference in a new issue
Codeberg/Community
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?