SQLite Forum

Window RAM Disk no better than local SSD?
Login
I'm trying to build a SQLite database completely on an appropriately sized Windows 10 RAM disk (R:), where both inputs and outputs are on R:.  I am using sqlite3.exe command-line tool < test.ddl

Even though I'm setting TMP to R:\ I get the same run-time as when using the local (SSD) disk for inputs and outputs.

What I/O am I missing?  I would expect the .imports, DDL/DML, and writes to be much, much faster than SSD.

Thanks,
Bradley