Ugh.

you are viewing a single comment's thread
view the rest of the comments
[–] -1 points 3 years ago* (2 children)

That’s why I use lemm.ee

1993: God, how we would love it if someone could tell us anything was “just that simple”, and then of course when you see a pie chart you go “Oh, a pie chart…”. I mean, it has more religious meaning now than a crucifix to see a pie chart. I mean, because…. why is that so popular? Because it reduces complexity. The complexity is very real but his little soundbites - 1993

@garpunkal@lemm.ee - do you know of the history of site_aggregates PostgreSQL table?

  • source
  • parent
  • hideshow 4 child comments
  • [–] 1 point 3 years ago (1 child)
  • [–] 1 point 3 years ago (1 child)
  • [–] 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.

  • source
  • parent