this post was submitted on 16 Mar 2025

892 points (98.8% liked)

Programmer Humor

21609 readers

2168 users here now

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.

Rules

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

Feyter@programming.dev

anzo@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

892

muskrat's data eng expert's hard drive overheats while processing 60k rows (lemmy.dbzer0.com)

submitted 1 day ago by SchwertImStein@lemmy.dbzer0.com to c/programmer_humor@programming.dev

281 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] surph_ninja@lemmy.world 30 points 21 hours ago* (last edited 21 hours ago) (1 children)

I run queries throughout the day that can return 8 million+ rows easily. Granted, it takes few minutes to run, but it has never caused a single issue with overheating even on slim pc’s.

This makes no fucking sense. 60k rows would return in a flash even on shitty hardware. And if it taxes anything, it’s gonna be the ram or cpu- not the hard drive.

[–] T156@lemmy.world 2 points 10 hours ago* (last edited 10 hours ago)

In my experience, the only time that I've taxed a drive when doing a database query is either when dumping it, or with SQLite's vacuum, which copies the whole thing.

For a pretty simple search like OP seems to be doing, the indices should have taken care of basically all the heavy lifting.