RoundSparrow @ PD

  • 1 Post
  • 7 Comments
Joined 2 years ago
cake
Cake day: June 11th, 2023

help-circle




  • RoundSparrow @ PDtoProgramming.dev MetaCall for Assistance
    link
    fedilink
    English
    arrow-up
    4
    ·
    edit-2
    2 years ago

    I suggestion that someone create a shell client stress-test app for the server API. Do a login, do a listing of postings, do a listing of communities, access a user profile, access a posting with 10 comments and another with 150 comments, etc… Measure the response time and output it in a simple format that different admins can share and identify slow areas within the lemmy_server code.

    The problem seems to be rooted in the lack of generating enough dummy test data for the lemmy-server app… it was only incrementally tested with low activity that was on the Lenny network before May 2023… now it is 100x or more data in the comments, upvotes, users, etc.

    Each new comment and posting is making servers slower, the SQL is jut not scaling with the current table structures and JOIN usage.