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

Programmer Humor

21610 readers
1816 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
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] T156@lemmy.world 0 points 1 day ago* (last edited 1 day ago) (1 children)

Unless they actually mean the hard drive, and not the computer. I've definitely had a cheap enclosure overheat and drop out on me before when trying to seek the drive a bunch, although it's more likely the enclosure's own electronics overheating. Unless their query was rubbish, a simple database scan/search like that should be fast, and not demanding in the slightest. Doubly so if it's dedicated, and not using some embedded thing like SQLite. A few dozen thousand queries should be basically nothing.

[โ€“] zenpocalypse@lemm.ee 1 points 51 minutes ago

Yeah, no matter what way you disorganize 60,000 rows, the data is still going to read into memory once.