Programmer Humor

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.

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.

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.

You can put 60k rows in Excel 95.

You're giving this person a lot of credit. It's probably all in the same table and this idiot is probably doing something like a for-loop over an integer range (the length of the table) where it pulls the entire table down every iteration of the loop, dumps it to a local file, and then uses plain text search or some really bad regex's to find the data they're looking for.

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

Have you ever heard of case of overheating hard drives within the last decade?

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".

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.

Even if querying data was processing-heavy and even if somehow the ‘hard drive’ got warm during this, then there still would need to be a hardware defect in order for the drive to overheat.

60k is laughably, embarrassingly small. It's still sqlite-sized.

A TI-86 can query 60k rows without breaking a sweat.

If his hard drive overheated from that, he is doing something very wrong, very unhygienic, or both.

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.