this post was submitted on 16 Mar 2025
927 points (98.7% liked)

Programmer Humor

21609 readers
2044 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

founded 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
927
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
296 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 1 day ago* (last edited 1 day 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 14 hours ago* (last edited 14 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.