Programmer Humor

21568 readers

2283 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

[email protected]

764

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

submitted 20 hours ago by [email protected] to c/[email protected]

253 comments fedilink hide all child comments

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

[–] [email protected] 1 points 2 hours ago

Out of memory/overheating in 60k rows? I've had a few multi-million row databases that could fit into a few gigs of memory, and most modern machines have that much in RAM. A 60k query that overheats the machine might only happen if you're doing something weird with joins.

Plus a lot of reads is nothing really, for basically all databases, unless you're doing an unsmart thing with how you're reading it (like scanning the whole database over and over). If you're not processing the data, it'd be I/O bottlenecked.