3 ms·
Dude, frack no. Having everything in a database means you are tied to the speed of disk, instead of the speed of ram. The biggest issue with being purely ram re
by DomesticMouse 18y ago
Dude, frack no. Having everything in a database means you are tied to the speed of disk, instead of the speed of ram. The biggest issue with being purely ram resident is handling multi-threaded updates across your ram resident dataset.
You could always use Erlang...
- ajkirwin 18y agoThat's why you use intelligent caching.
- sounddust 18y agoFor a site this small, there's absolutely no reason the entire database shouldn't be cached in RAM. 32GB of RAM costs about $800. That buys you plenty of time to not have to worry about caching, and instead gives you more time to work on interesting features. For a single-person operation (or even a few people), you have to spend your time wisely.
- jrockway 18y agoBut of course, any sane database will cache as much in RAM as possible anyway. But instead of dying when you run out of memory, it just evicts the least recently used page.
- nikblack 18y ago"Dude, frack no. Having everything in a database means you are tied to the speed of disk, instead of the speed of ram. " database are not tied to a storage medium. there is no reason why you can't run a DB (key-val or even a full RDBMS) in RAM.
- jcl 18y agoIf everything is purely RAM resident, wouldn't you lose it all when the server gets wedged?
- sounddust 18y agoNo. You journal the changes to disk. You therefore only need disks fast enough to keep up with the journal. If you get into a situation where your disks can't keep up with the journal, your site is probably big and popular enough that you can afford to hire DBAs to go from there.