On 25 Mar 2012, at 2:16am, Udi Karni <uka...@gmail.com> wrote: > (2) On Windows - a RamDisk "drive letter" can be used beneficially in 2 > ways - > (a) to contain the database itself > (b) to serve as a destination for the TEMP and TMP - which SQLite (through > Windows I suppose) uses often as a scratchpad. > Is it possible - good/bad idea - to point the Windows TMP and TEMP to a > "virtual" drive letter on top of a RamDisk? The RamDisk gets established as > Windows comes up - but the question is whether Windows might need the TMP / > TEMP prior to that point in time - when they are not yet going to be > available - causing startup problems?
There is a separate mechanism for creating in-memory databases: specify ':memory:' as the file name. So SQLite lets the programmer choose which one they want. By moving TMP/TEMP to memory too all you're doing is reducing your options. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
