SQLite Forum

Temporary data when running out of memory
Login
Hi, if I set the SQLITE_TEMP_STORE compilation option to 2 (and don't use the temp_store PRAGMA) or 3, and run out of main memory, does SQLite autonomously write temporary data to the disk or is it left to the operating system to swap memory to disk (or not if it's marked as not swappable)?