• rumba@lemmy.zip
    link
    fedilink
    English
    arrow-up
    132
    ·
    7 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.

    • exu@feditown.com
      link
      fedilink
      English
      arrow-up
      85
      arrow-down
      1
      ·
      7 days ago

      Can’t be a relational database, Musk said the government doesn’t use SQL.

    • iAvicenna@lemmy.world
      link
      fedilink
      arrow-up
      17
      ·
      6 days ago

      yes but also why say 60K when you could have literally said anything? I mean surely the fact that he thinks 60K rows a big number is already explaining alot lol.

      • Melvin_Ferd@lemmy.world
        link
        fedilink
        arrow-up
        9
        ·
        edit-2
        6 days ago

        It’s bait.

        They probably have an explanation tweet at the ready to make more sense of it. They just want enough 'hurr durr these idiot" comments before they reverse Uno card this with more context.

        • iAvicenna@lemmy.world
          link
          fedilink
          arrow-up
          7
          ·
          6 days ago

          Based on all that has been going on, I feel like they don’t really have the capacity to think more than one step ahead. They do sth stupid and then they usually follow up with “lol joke” or “lol you can’t understand”

          • Melvin_Ferd@lemmy.world
            link
            fedilink
            arrow-up
            1
            ·
            edit-2
            6 days ago

            Wait, seriously?

            I don’t get how people don’t see this stuff. Yea the average trumpet isn’t out there planning Jack shit. But there are think tanks that are. Remember anti-smoking campaigns. Anti climate change campaign. The precision to purchase advertising into key areas and specific demographics that would spread a message. This is ancient knowledge with modern technology.

            Imagine a room full of former Wall Street, quants, established experts from fields like behavioral science and psychology. All with the singular goal to decide where to dedicate a dragons horde of wealth to maximize effect in a world where we all have anonymous pipes directly into our eyes and ears. We never stood a chance. There’s no rich socialist funding think tanks. There’s no counter. We can laugh at the yokel all we want. But the yokel is being puppeteered by some scary fuckers with intention to seize power with the new shifting Zeitgeist. Soldiers don’t need to think. But their generals are. The left are like guerilla fighters going up against an imperial army full of Patons and Eisenhower’s.

            Cambridge analytical, heritage foundation, international democracy Union. We’re fucked until we actually recognize why we’re fucked

    • ameancow@lemmy.world
      link
      fedilink
      English
      arrow-up
      9
      arrow-down
      1
      ·
      edit-2
      6 days ago

      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.

      Honestly, any sweet, white-haired old lady who keeps pictures of her dogs and grandkids on her desk who’s been doing data entry for 15 years could do circles around these clowns.

      But she might also have the wisdom and perception to know we’re not supposed to be doing this “work” at all, which is why he recruits naive teenagers and college kids who are still emotionally immature to think that this is going to be their “destiny” or their opportunity to get into the big leagues of business.

      • rumba@lemmy.zip
        link
        fedilink
        English
        arrow-up
        3
        ·
        6 days ago

        I keep hearing things about these hires he has, I don’t think they’re naive, At least not as such. They seem to be more power hungry trust fund babies.

        But yeah, people with a few years in them would be a moral liability in that line of work.

        • easily3667@lemmus.org
          link
          fedilink
          English
          arrow-up
          2
          ·
          6 days ago

          Yeah if you read more of these guys tweets they are clearly in politics. One message tried to claim trump loves kids (to be clear: in the abstract sense, not in the he definitely fucked kids on an island with Epstein sense). Then they tried to twist the words to say “why don’t you love kids”. It was clumsy like you’d expect from someone who is practically a teenager, but the core is an attempt to follow the usual right wing playbook.

    • Deathray5@lemmynsfw.com
      link
      fedilink
      arrow-up
      9
      ·
      7 days ago

      Somehow I feel over clicking without understanding of the consequences sounds like something a techbro would do

  • Harbinger01173430@lemmy.world
    link
    fedilink
    arrow-up
    68
    arrow-down
    1
    ·
    6 days ago

    Even a gamer knows that ssdd heat up but never to that level, lol.

    What kind of cheap temu ssd does he have in his laptop?

  • LillyPip@lemmy.ca
    link
    fedilink
    arrow-up
    93
    ·
    7 days ago

    This cannot be real, wtf. This is cartoon levels of ineptitude.

    Or sabotage by someone heading out? Please let this be resistance sabotage they haven’t noticed yet.

  • RussianBot8453@lemmy.world
    link
    fedilink
    arrow-up
    100
    ·
    7 days ago

    I’m a data engineer that processes 2 billion row 3000 column datasets every day, and I open shit in Excel with more than 60k rows. What the hell is this chick talking about?

    • zenpocalypse@lemm.ee
      link
      fedilink
      English
      arrow-up
      28
      ·
      7 days ago

      Seems like a good excuse to someone who doesn’t know what they’re doing and needs an excuse because why they haven’t completed it yet?

      The whole post is complete bs in multiple ways. So weird.

      • Akasazh@feddit.nl
        link
        fedilink
        arrow-up
        6
        ·
        7 days ago

        If you work for a boss that fundamentally misunderstands what you are doing, then misleading them into thinking you’re ‘hard at work, making decisions with consequences’ is the theatre you put up to keep the cash flowing.

        It’s one of the fundamental flows of autocracy, people try and represent what you want them to

      • psivchaz@reddthat.com
        link
        fedilink
        arrow-up
        4
        ·
        6 days ago

        It sounds like Hollywood tech lingo. Like when you’re watching a movie or a TV show and the designated techy character starts just saying computer words that make no actual sense in the real world, but I guess in CSI: Idiottown the hard drives have severe overheating issues.

    • person420@lemmynsfw.com
      link
      fedilink
      arrow-up
      24
      ·
      7 days ago

      Some interesting facts about excel I learned the hard way.

      1. It only supports about a million or so rows
      2. It completely screws up numbers if the column is a number and the number is over 15 digits long.

      Not really related to what you said, but I’m still sore about the bad data import that caused me days of work to clean up.

      • Mniot@programming.dev
        link
        fedilink
        English
        arrow-up
        9
        ·
        7 days ago

        The row limitation seems, to me, like an actually-good thing. Excel is for data where you might conceivably scroll up and down looking at it and 1M is definitely beyond the ability of a human even to just skim looking for something different.

        An older version of Excel could only handle 64k rows and I had a client who wanted large amounts of data in Excel format. “Oh sorry, it’s a Microsoft limitation,” I was thrilled to say. “I have no choice but to give you a useful summarization of the data instead of 800k rows (each 1000 columns wide) of raw data.”

        • frezik@midwest.social
          link
          fedilink
          arrow-up
          3
          ·
          edit-2
          6 days ago

          Some time ago, I heard a story of CS and Econ professors having lunch together. The Econ professor was excited that Excel was going to release a version that blew out the 64k row limit. The CS professor nearly choked on his lunch.

          Dependence on Excel has definitely caused bad papers to be published in the Econ space, and has had real world consequences. There was a paper years ago that stated that once a country’s debt gets above 120% of GDP, its economy goes into a death spiral. It was passed around as established fact by the sorts of politicians who justify austerity. Problem was, nobody could reproduce the results. Then an Econ undergrad asked the original author for their Excel spreadsheet, and they found a coding error in the formulas. Once corrected, the conclusion disappeared.

      • driving_crooner@lemmy.eco.br
        link
        fedilink
        arrow-up
        8
        ·
        edit-2
        7 days ago

        It completely screws up numbers if the column is a number and the number is over 15 digits long.

        I work in insurance in Brazil, by standards of our regulatory body, claims numbers must be a string of 20 numbers (zfill(20) if needed). You can’t imagine the amount of times excel had fucked me up rounding down the claim numbers, this is one of the first things I teach to my interns and juniors when they’re working with the claims databases.

          • driving_crooner@lemmy.eco.br
            link
            fedilink
            arrow-up
            1
            ·
            6 days ago

            Sure, but sometimes you need to do a pivot table and get transformed, or you while working you accidentally made it a number, or just because excel being excel it import the number as scientific notation, or any other case.

  • BenLeMan@lemmy.world
    link
    fedilink
    arrow-up
    72
    ·
    7 days ago

    You’re not supposed to place your laptop directly in the lap of your fur suit. Always leave an air gap for ventilation, smh.

    • wewbull@feddit.uk
      link
      fedilink
      English
      arrow-up
      23
      arrow-down
      2
      ·
      7 days ago

      Doesn’t actually say that 60k overheated his drive. He says that he ran a run on 60k, and that he couldn’t do the whole database due to overheating. Two unrelated statements except that 60k is the lower bound for what he could process.

      Doesn’t mean he knows what he’s doing though, as pretty huge datasets are processable on quite modest hardware if you do it right.

    • wise_pancake@lemmy.ca
      link
      fedilink
      arrow-up
      6
      ·
      7 days ago

      Are you telling me there’s a difference between an inner and a cross join?

      Cross join is obviously faster, I don’t even have to write “on”

  • nonentity@sh.itjust.works
    link
    fedilink
    arrow-up
    50
    ·
    7 days ago

    Either she knows something novel, where processing data using voice coils is somehow beneficial, or is someone who calls their computer a ‘hard drive’, which summarily negates any legitimacy of technical competence.

  • jkercher@programming.dev
    link
    fedilink
    English
    arrow-up
    37
    ·
    7 days ago

    60k rows of anything will be pulled into the file cache and do very little work on the drive. Possibly none after the first read.

  • MystikIncarnate@lemmy.ca
    link
    fedilink
    English
    arrow-up
    15
    ·
    edit-2
    5 days ago

    IT guy checking in.

    The only time I’ve even seen drive temp sensor alarms is on server raid arrays and other similar hard drives/SSDs… Never in my life have I seen one available on a consumer device, nor have I seen any alarm for and drive temp, go off. It just doesn’t happen.

    IMO, this is one of those language barriers where people call their computer chassis (and everything in it) the “hard drive”.

    Applying that assumption, their updated statement is: His computer over heated.

    Idk what kind of shit system he’s running on that 60k rows would cause overheating, but ok.