• zalgotext@sh.itjust.works
    link
    fedilink
    arrow-up
    84
    arrow-down
    1
    ·
    18 hours ago

    my hard drive overheated

    So, this means they either have a local copy on disk of whatever database they’re querying, or they’re dumping a remote db to disk at some point before/during/after their query, right?

    Either way, I have just one question - why?

    • Bosht@lemmy.world
      link
      fedilink
      English
      arrow-up
      37
      ·
      16 hours ago

      I’d much sooner assume that they’re just fucking stupid and talking out of their ass tbh.

      • kautau@lemmy.world
        link
        fedilink
        arrow-up
        15
        ·
        edit-2
        12 hours ago

        Same as Elon when he confidently told off engineers during his takeover of Twitter or gestures broadly at the Mr. Dunning Kruger himself

        Wonder if it’s an SQL DB

        Elon probably hired confident right wingers whose parents bought and paid their way through prestigious schools. If he hired anyone truly skilled and knowledgeable, they’d call him out on his bullshit. So the people gutting government programs and passing around private data like candy are just confidently incorrect

      • Fuck spez@sh.itjust.works
        link
        fedilink
        English
        arrow-up
        5
        ·
        14 hours ago

        I don’t think I’ve seen a brand new computer in the past decade that even had a mechanical hard drive at all unless it was purpose-built for storing multiple terabytes, and 60K rows wouldn’t even take multiple gigabytes.

      • baldingpudenda@lemmy.world
        link
        fedilink
        arrow-up
        4
        ·
        16 hours ago

        Reminds me of those 90s ads about hackers making your pc explode.

        Musk gonna roll up in a wheelchair, “the attempt on my life has left me ketamine addicted and all knowing and powerful.”

      • wise_pancake@lemmy.ca
        link
        fedilink
        arrow-up
        1
        ·
        11 hours ago

        I have when a misconfigured spark job I was debugging was filling hard drives with tb of error logs and killing the drives.

        That was a pretty weird edge case though, and I don’t think the drives were melting, plus this was closer to 10 years ago when SSD write lifetimes were crappy and we bought a bad batch of drives.

    • zenpocalypse@lemm.ee
      link
      fedilink
      English
      arrow-up
      14
      ·
      edit-2
      14 hours ago

      Even if it was local, a raspberry pi can handle a query that size.

      Edit - honestly, it reeks of a knowledge level that calls the entire PC a “hard drive”.

      • T156@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        arrow-down
        1
        ·
        edit-2
        6 hours ago

        Unless they actually mean the hard drive, and not the computer. I’ve definitely had a cheap enclosure overheat and drop out on me before when trying to seek the drive a bunch, although it’s more likely the enclosure’s own electronics overheating. Unless their query was rubbish, a simple database scan/search like that should be fast, and not demanding in the slightest. Doubly so if it’s dedicated, and not using some embedded thing like SQLite. A few dozen thousand queries should be basically nothing.

    • GoodEye8@lemm.ee
      link
      fedilink
      English
      arrow-up
      21
      arrow-down
      1
      ·
      16 hours ago

      My one question would be “How?”

      What the hell are you doing that your hard drives are overheating? How do you even know it’s overheating as I’m like 90% certain hard drives (except NVMe if we’re being liberal with the meaning of hard drive) don’t even have temperature sensors?

      The only conclusion I can come to is that everything he’s saying is just bullshit.

      • Auli@lemmy.ca
        link
        fedilink
        English
        arrow-up
        16
        ·
        16 hours ago

        They have temp sensors. But have never heard of a overheating drive.

          • Mniot@programming.dev
            link
            fedilink
            English
            arrow-up
            4
            ·
            13 hours ago

            Can we think of any device someone might have that would struggle with 60k? Certainly an ESP32 chip could handle it fine, so most IoT devices would work…

            • T156@lemmy.world
              link
              fedilink
              English
              arrow-up
              1
              ·
              6 hours ago

              Unless the database was designed by someone who only knows of data as that robot from Star Trek, most would be absolutely fine with 60k rows. I wouldn’t be surprised if the machine they’re using caches that much in RAM alone.

            • zenpocalypse@lemm.ee
              link
              fedilink
              English
              arrow-up
              4
              ·
              13 hours ago

              Right? There’s no part of that xeet that makes any real sense coming from a “data engineer.”

              Terrifying, really.

    • Adalast@lemmy.world
      link
      fedilink
      arrow-up
      4
      arrow-down
      1
      ·
      17 hours ago

      Why? Because they feel the need to have local copies of sensitive financial information because… You know… They are computer security experts.