Ugh.

  • RoundSparrow@lemmy.ml
    link
    fedilink
    arrow-up
    2
    arrow-down
    6
    ·
    edit-2
    1 year ago

    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?

      • RoundSparrow@lemmy.ml
        link
        fedilink
        arrow-up
        1
        arrow-down
        4
        ·
        edit-2
        1 year ago

        huh?

        Please explain in detail what “huh” means in this context.

        As I said in the comment you replied to: do you know of the history of site_aggregates PostgreSQL table?

        • WarmSoda@lemm.ee
          link
          fedilink
          arrow-up
          2
          ·
          1 year ago

          Not OP, but I feel like it was Huh? as in what the heck are you talking about and why was it a reply to thier comment

      • RoundSparrow@lemmy.ml
        link
        fedilink
        arrow-up
        1
        ·
        1 year 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.