• flere-imsaho
    link
    fedilink
    English
    arrow-up
    13
    arrow-down
    2
    ·
    edit-2
    1 year ago

    they also stored this thing as a fucking string. looking up strings is costly.

    • froztbyte
      link
      fedilink
      English
      arrow-up
      13
      ·
      1 year ago

      naw bro we’ve got indexes bro it’ll be fine bro

      • froztbyte
        link
        fedilink
        English
        arrow-up
        10
        ·
        1 year ago

        can’t wait for the Clever Idea to offload costly string indices to an external source composed of redis box and some shitfuck app doing tf-idf after a Extensive Research into how to make string lookups be faster

    • 𝙲𝚑𝚊𝚒𝚛𝚖𝚊𝚗 𝙼𝚎𝚘𝚠@programming.devBanned
      link
      fedilink
      English
      arrow-up
      3
      arrow-down
      10
      ·
      1 year ago

      This sounds like a case of premature optimization to me. We have plenty of databases using strings as Ids and they’re all more than fast enough for any of our purposes. And that’s with considerable volume going through.

      I’ve never seen bad performance from string ids be an issue.