Does anyone know if :memory: databases still use a cache? We are using Sqlite in a game and are very tight on memory. I'm wondering if it would be good for us to reduce the cache size to 0 (or something very small), and if there would be any performance penalty for doing so. It seems like there shouldn't be because the DB is already in RAM - it seems like the cache would only add extra memory copies and slow things down. But that is my naïve assumption.
Anyone know? Thanks, Dave