There are two
pragmas that govern temporary storage: temp_store and temp_store_directory. The first pragma
determines whether SQLite uses memory or disk for temporary storage. There are actually three possible
values: default, file, or memory. default uses the compiled-in default, file uses an operating system file,
and memory uses RAM. If file is set as the storage medium, then the second pragma,
temp_store_directory, can be used to set the directory in which the temporary storage file is placed.