980
muskrat's data eng expert's hard drive overheats while processing 60k rows (lemmy.dbzer0.com)
submitted 2 years ago by to c/programmer_humor@programming.dev
292 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 31 points 2 years ago* (1 child)

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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 2 points 2 years 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.

  • permalink
  • fedilink
  • source
  • parent