• 0 Posts
  • 18 Comments
Joined 1 year ago
cake
Cake day: June 9th, 2023

help-circle















  • The difference is the server doesn’t need to scan the giant vote table for ordinary polling or ranked posts.

    Unless there was significant optimization work done on the DB schema, this approach would require joining the large posts table to the very large user-post-ranking table for each request for sorted posts.

    This will kill DB performance without some sort of clustering or sharding.


  • deegeese@sopuli.xyztoFediverse@lemmy.world*Permanently Deleted*
    link
    fedilink
    English
    arrow-up
    5
    ·
    edit-2
    10 months ago

    If the server sends posts, and the client computes the ordering, the client has to do the sorting.

    The “hot” thing is just server side caching of scores for a server side sort.

    What you seem to be suggesting is that the server support storing post scores sent from clients so it can feed that sort back to the client. I don’t think that would scale for millions of users storing their preferred post sorting order on the server.