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?
60k of rows is nothing. Fuck, where do you find these “geniuses”?
Tbf we don't know how many columns there are /s
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.
music theaters also have rows, and they run on sql so logic checks out.
Can't be a relational database, Musk said the government doesn't use SQL.
Lol he also said cybertrucks don't suck ;)
grep would eat 60k lines without a problem too.
He said many things.
Somehow I feel over clicking without understanding of the consequences sounds like something a techbro would do
You're not supposed to place your laptop directly in the lap of your fur suit. Always leave an air gap for ventilation, smh.
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.
You guys arent running your software off raspberry pi's with sdcards from the gas station?
My allowance is 5$ a month!
Look, all I’m saying is give Pis a chance.
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.
Or wrote the code using AI without checking what it exactly does.
The AI probably used bogosort or something equivalent
I will now attempt a full comment ... brace your hard drives
“I store my records on vinyl. You’ve probably never heard of them.”
I smell something, but it's not overheating electronics.
I've processed over 5 million records on a laptop that's almost 10 years old. it took two days to get my results.
there's no way 60,000 records overheated ANYTHING.
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.
that's somehow worse.
a "data analyst" couldn't cut up the work into a parallel processes and run them synchronously? what the actual fuck?
"sorry, I can only do 60k at a time."
just fucking split them up into 6 parallel batch processes running 10k at a time. it's fucking math, not rocket science. I'm not even an analyst and I could fucking do that much.
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.
You can put 60k rows in Excel 95.
Not if each row is pi!
I didn't know hard drive overheating was a thing. Should I be worried that my 5 year old hard drive is about to overheat. I mean is this actually a floppy disk or something?
it is a thing, but any competently designed computer should have things in place to prevent this.
unless you're an arrogant dipshit and disable all the hardware safeties on your computer to make it go faster and wear harder.
When an HDD works continuously it can heat up to above 60 °C if proper air circulation is not allowed, which can cause a very premature failure. In fact, it should be kept under 40 °C to achieve the intended lifespan. Unfortunately, PC cases are usually not great at removing heat from the HDD by default.
As for your drive, it most likely has a temperature sensor so it can be displayed by various utilities.
I have a 12v fan running at 5v spitting air on my hdds, and that's enough for them to go from 55°C to 29°C, lol.
I did that too, the tiny fan is pretty much silent at 5V. The HDD has so much surface area it only needs a little air circulation.
it is, in the select event that your platter bearing fails, in which case it would be very, very obvious.
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?
When the only thing that is stopping kids from dismantling your government is an O(N^N) algorithm
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
