Major hardware upgrade: https://lemm.ee/post/523075

The slow votes on Lemmy.ml, the open GItHub issue, insert times on the data - and lots of other things would benefit from caching layer. Way too much is being live-queried from PostgreSQL… Create a dummy response if you have to when score: 1 is set, and cache those inserts at the API layer.

If server logs had been openly shared weeks ago, a lot of these timeouts and crashes would have been identified in the Rust code.

There really is not that much data here, it’s the application internal caching and buffering that is missing.