I use the "All new" view (no subscribed filter) and never had any issue so I guess it doesn't matter
Lemmy
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
Good point! I should have thought about that ... I just don't use that feed. There's a chance that it's relatively efficient because it'd be the same for everyone and so is basically calculated once for the whole instance.
Once for the whole instance
Not necessarily. I have a very long blocked communities list which is likely unique to me. I believe thats taken into account when pulling /all
Even the person to person blocking is taking into consideration with that query. Lemmy's SQL output isn't well optimized for caching, it puts a lot of work on PostgreSQL to customize these views. It is only users who are not logged-in that would get a repeatable query.