If you're running a pcie nvme ssd, one of the modern ones, and you're doing a SHIT ton of reads, like threadripper level amount of reads, i guess "overheating" isn't unexpected? Shouldn't do much other than slow down the SSD though?

dumbass probably loaded them into memory, and OOM'd, and thought it was the drive.

[–] T156@lemmy.world 3 points 1 day ago (1 children)

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.

[–] KillingTimeItself@lemmy.dbzer0.com 2 points 17 hours ago

if they wrote good code yeah, evidently they didn't write good code if they're struggling to process 60k lines of a database lmao.

They must either be O(n^10) complexity or something retarded like that for this to be the case. I wouldn't put it past them.

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.

again, i'm assuming they aren't very smart, since this is an issue in the first place.

[–] lefaucet@slrpnk.net 5 points 1 day ago (2 children)

NVMEs will throttle if they are inadequately cooled. Pretty much only folks who are new at buiding computers and don't adequately cool their NVMEs experience this.

Either way it shows what a clown show this is. I'm pretty sure they're doing some babuki theatre to distract us and then if the scheme being done here is found, they'll point fingers at the dipshit kid and he'll be punished for whatever the con is.

Either way the billionaires will be better off for it, barring judicial, congressional, or military revolt; which is looking less likely by the day.

Bunch of traitors forgot their oath is to the constitution. The constitution IS the soul of the country and is to be respected. The country was founded by the constitution and it defines the system to be decentralized power giving control to the populace through three different branches of government. Not some false idol king or an evil oligarchy propped up by foreign and domestic robber barrons

[–] KillingTimeItself@lemmy.dbzer0.com 1 points 17 hours ago

NVMEs will throttle if they are inadequately cooled. Pretty much only folks who are new at buiding computers and don’t adequately cool their NVMEs experience this.

yeah, but it shouldn't be that significant though right? You're talking like 10% slower speeds to anywhere probably like 50% of the speed, which for modern NVME ssds is basically perfectly usable in most cases. But i'm not up to speed on pcie 4.0 and 5.0 ssds, so idk the specifics.

[–] Static_Rocket@lemmy.world 1 points 1 day ago* (last edited 1 day ago)

Or it's a cheap external nvme chassis with a Samsung 980 Pro. Had to run that when I was copying files from one of my old machines and boy, it will absolutely overheat to the point of failure.

Gave me quite the scare when I started getting read errors and then it dropped off the bus. It shutdown to protect itself but it certainly didn't seem like that at the time.