▲ 85 ▼ Lemmy World is down once again. (lemmy.ml) submitted 3 years ago by favrion@lemmy.ml to c/fediverse@lemmy.ml 114 comments fedilink hide all child comments Ugh.
[–] garpunkal@lemm.ee 1 point 3 years ago (1 child) no tell me more? permalink fedilink source parent hideshow 2 child comments replies: [–] RoundSparrow@lemmy.ml 1 point 3 years ago lemmy.ca staff was so frustrated with performance problems a couple weekends ago they cloned a copy of their database Running AUTO_EXPLAIN revealed site_aggregates logic in Lemmy was doing comment = comment + 1 counting against 1500 rows, for every known Lemmy instance in the database, instead of just writing 1 row. permalink fedilink source parent
[–] RoundSparrow@lemmy.ml 1 point 3 years ago lemmy.ca staff was so frustrated with performance problems a couple weekends ago they cloned a copy of their database Running AUTO_EXPLAIN revealed site_aggregates logic in Lemmy was doing comment = comment + 1 counting against 1500 rows, for every known Lemmy instance in the database, instead of just writing 1 row. permalink fedilink source parent