60k isn't that much, I frequently run scripts against multiple hundreds of thousands at work. Wtf is he doing? Did he duplicate the government database onto his 2015 MacBook Air?

[–] easily3667@lemmus.org 2 points 2 weeks ago (2 children)

60k is laughably, embarrassingly small. It's still sqlite-sized.

[–] naught@sh.itjust.works 2 points 2 weeks ago

i mean its even excel sized depending on how many columns. This is seriously sad and alarming

[–] morrowind@lemmy.ml 1 points 2 weeks ago (1 children)

Sqlite can easily handle millions of rows. Don't sell it short

[–] The_Decryptor@aussie.zone 1 points 2 weeks ago

How about a 6.4TB sqlite database?

https://boyter.org/posts/searchcode-bigger-sqlite-than-you/

[–] 30p87@feddit.org 1 points 2 weeks ago

My fucking events table of my synapse DB in postgres is nearly ten times as large, and I ported that from sqlite no long ago, in a matter of minutes. All of the data is on a 2*3 cluster of old 256GB SSDs, equaling about 1.5TB with Raid 0. That's neither really fast, nor cool. But stable.

[–] 4am@lemm.ee 1 points 2 weeks ago

A TI-86 can query 60k rows without breaking a sweat.

If his hard drive overheated from that, he is doing something very wrong, very unhygienic, or both.