this post was submitted on 06 Aug 2023
1191 points (98.9% 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.