this post was submitted on 12 Jun 2023
333 points (99.1% liked)

Lemmy.World Announcements

28381 readers
1 users here now

This Community is intended for posts about the Lemmy.world server by the admins.

Follow us for server news 🐘

Outages 🔥

https://status.lemmy.world

For support with issues at Lemmy.world, go to the Lemmy.world Support community.

Support e-mail

Any support requests are best sent to [email protected] e-mail.

Report contact

Donations 💗

If you would like to make a donation to support the cost of running this platform, please do so at the following donation URLs.

If you can, please use / switch to Ko-Fi, it has the lowest fees for us

Ko-Fi (Donate)

Bunq (Donate)

Open Collective backers and sponsors

Patreon

Join the team

founded 2 years ago
MODERATORS
 

I'm trying to fix this annoying slowness when posting to larger communities. (Just try replying here...) I'll be doing some restarts of the docker stack and nginx.

Sorry for the inconvenience.

Edit: Well I've changed the nginx from running in a docker container to running on the host, but that hasn't solved the posting slowness..

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 3 points 1 year ago* (last edited 1 year ago) (2 children)

Somehow I don’t think the slowness when posting or saving is due to the nginx server / reverse proxy running inside the container.

I would still think it’s related to inserts and updates in the DB, but I haven’t had time to look into it on my instance, sorry!


Edit wait! Posting and saving is fast now! What did you change? Nicely done! 👍

[–] [email protected] 4 points 1 year ago (1 children)

No it's not! Not for me anyway. Yes I'll be looking into that, but first migrate the server!

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago)

Oh wait, that’s because I’m posting to Lemmy.world from my instance. It’s only slow when posting to Lemmy.world from a Lemmy.world user.

With that in mind, it makes me think it has something to do with some insert or update that happens. My local DB is not under load, so my save is fast. Lemmy.world’s DB is under load so the save is slow.

It might not even be the insert/update that is slow. Could be some other insert into another table that gets triggered on save that is the culprit.

[–] [email protected] 2 points 1 year ago (1 children)

Posting seems faster when posting to a non-local federated community. Maybe that's what you experienced?

[–] [email protected] 2 points 1 year ago

You are right. Good catch.