Lemmy "Subscribed" page loads slower than "All"? (slrpnk.net)

submitted 2 weeks ago by srasmus@slrpnk.net to c/fediverse@lemmy.world

18 comments fedilink hide all child comments

Hello all,

Apologies if this isn't the right place, but I have moved instances a few times, and in doing so I've accumulated a number of subscriptions from my old instances. I always used the "migrate" feature, and I have roughly 200 communities I'm subscribed to. Most are from various other instances that aren't my own. That being said, I have Lemmy open on "subscribed" and "scaled", as I found this gives me just what I want to see when I boot up the site.

But it is very slow, sometimes even timing out on Jerboa. I thought it was my instance, but I've had this issue on other instances as well. I'd imagine federating all my subscriptions would take some time, but then wouldn't "All" cause even more problems? I've tried to look into this to no avail.

Am I the only one? I'm asking this more out of curiosity than an actual solution.

you are viewing a single comment's thread
view the rest of the comments

[-] SlurpingPus@lemmy.world 5 points 2 weeks ago* (last edited 2 weeks ago)

Strictly speaking, the db might be looking in an index to choose rows by the communities — but using such a condition is pretty much guaranteed to be slower than not using it, anyway.

The actual answer depends on the actual database organization, of course. Ideally the whole database should be organized around frequent queries.