Load existing SQLite database to memory

Question

I have an existing database in a file. I want to load the database in memory; because I'm doing a lot queries and the database isn't very large (<50MB) to fasten those queries. Is there any way to do this?

Answer 1

50 MB easily fits in the OS file cache; you do not need to do anything.

If the file locking results in a noticeable overhead (which is unlikely), consider using the exclusive locking mode.