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