SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?

Why is :memory: in sqlite so slow? I’ve been trying to see if there are any performance improvements gained by using in-memory sqlite vs. disk based sqlite. Basically I’d like to trade startup time and memory to get extremely rapid queries which do not hit disk during the course of the application. However, the following … Read more

Will Linux start killing my processes without asking me if memory gets short?

I was running a shell script with commands to run several memory-intensive programs (2-5 GB) back-to-back. When I went back to check on the progress of my script I was surprised to discover that some of my processes were Killed, as my terminal reported to me. Several programs had already successively completed before the programs that were later Killed started, but all the programs afterwards failed in a segmentation fault (which may or may not have been due to a bug in my code, keep reading).