Hello, John!
It would be nice to have option that just loads the db file into memory or otherwise caches the contents wholly in memory. Are there any caching options in sqlite that would mirror this behavior?
You could set the cache size as big as your database file (via pragma). This should load all (used) data into memory. This is probably not a good solution if your application does not run for a longer time.
Greetings, Dirk
