4 ms·
Is PRAGMA temp_store = MEMORY the same as putting the file on a TempFS?
by rmetzler 5y ago
Is PRAGMA temp_store = MEMORY the same as putting the file on a TempFS?
- elteto 5y agoMaybe, maybe not. I imagine writing directly to memory will always be faster than writing to a filesystem, even if it’s ultimately backed by RAM. Might be a negligible difference though.
- DemocracyFTW 5y agoI tried using tmpfs to create and exercise a file-based SQLite DB, and it performed significantly worse than a RAM-based DB (opened with an empty string or ':memory:').
- rmetzler 5y agoThank you :)