how to divorce two impl?
GREAT NEWS about Lemmy Server Performance, another major SQL mistake has been discovered today: every single comment & post create (INSERT) is updating ~1700 rows in the site_aggregates table
« Personne ne se rend compte que certaines personnes dépensent une force herculéenne pour être seulement normales. »
Test post that originated from Lemmy.ml instance, make me a mod!
Lemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmy
lemmy_server Rust code now exposes internal metrics via Prometheus endpoint
Big Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!
lemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crate
Lemmy PERFORMANCE CRISIS: popular instances with many remote instances following big communities could stop federating outbound for Votes on comments/posts - code path identified
PERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"
What are your must-have top features you’d want to see in a Lemmy app or web client? - /c/AskLemmy
lemmy_server should run a SHA256 checksum against every uploaded image and keep a database of all known images so that it does not have to store and link to exact uploads of the same image
I have, weeks ago.
I did share a link to GitHub, is that not good enough or something? Here is a screen shot for you.