this post was submitted on 06 Aug 2023
1453 points (99.1% liked)

Announcements

23319 readers
1 users here now

Official announcements from the Lemmy project. Subscribe to this community or add it to your RSS reader in order to be notified about new releases and important updates.

You can also find major news on join-lemmy.org

founded 5 years ago
MODERATORS
 

This is an opportunity for any users, server admins, or interested third parties to ask anything they'd like to @nutomic@lemmy.ml and I about Lemmy. This includes its development and future, as well as wider issues relevant to the social media landscape today.

Note: This will be the thread tmrw, so you can use this thread to ask and vote on questions beforehand.

Original Announcement thread

you are viewing a single comment's thread
view the rest of the comments
[–] dessalines@lemmy.ml 31 points 1 year ago

Tree-paging is a pretty complicated issue, and we really do need some DB / SQL experts to help us with figuring out how to page them correctly. The limit is 300, but only for the top-level comment fetch, which could also have different slices whether you sort by top, or new, and doesn't apply to the nested comments, which could have thousands.

The limit is a kludge, because ppl were creating thousands of comments, and without proper paging, it was affecting performance.