• T156@lemmy.world
    link
    fedilink
    English
    arrow-up
    3
    ·
    12 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.