• Psaldorn@lemmy.world
    link
    fedilink
    arrow-up
    1
    ·
    17 days ago

    From the same group that doesn’t understand joins and thinks nobody uses SQL this is hardly surprising .

    Probably got an LLM running locally and asking it to get data which is then running 10 level deep sub queries to achieve what 2 inner joins would in a fraction of the time.

  • Tiefling IRL@lemmy.blahaj.zone
    link
    fedilink
    arrow-up
    1
    ·
    17 days ago

    60k isn’t that much, I frequently run scripts against multiple hundreds of thousands at work. Wtf is he doing? Did he duplicate the government database onto his 2015 MacBook Air?

  • rumba@lemmy.zip
    link
    fedilink
    English
    arrow-up
    1
    ·
    17 days ago

    Unless I’m misreading it which is possible it’s awfully late, he said he processed 60,000 rows didn’t find what he was looking for but his hard drive overheated on the full pass.

    Discs don’t overheat because there was load. Even if he f***** up and didn’t index the data correctly (I assume it’s a relational database since he’s talking about rows) The disc isn’t just going to overheat because the job is big. It’s going to be lack of air flow or lack of heatsink.

    I guarantee you he was running on an external NVMe, and one of those little shitty-ass Chinese enclosures. Or maybe one of those self immolating SanDisk enclosures. Hell, maybe he’s on a desktop and he slept a raw NVMe on his motherboard without a heatsink

    There are times when you want a brilliant college student on your team, But you need seasoned professionals to help them through the things they’ve never seen before and never done before.

  • ryedaft@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    0
    ·
    18 days ago

    This sounds like trying to do stuff in Excel? The computer isn’t overheating but the amount of memory needed is very high which would make it run poorly. They might interpret that as overheating?

    • monkeyman512@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      ·
      18 days ago

      It also makes sense if they are on calling the entire computer “the hard drive” like grandma and the fans kicked on.