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

Programmer Humor

21609 readers
2090 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
915
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
290 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] T156@lemmy.world 2 points 13 hours ago* (last edited 13 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.