> Some temporary files have fixed names so they will be replaced the next > time SQLite tries to perform the same operation, and deleted when that one > finishes. Others will just hang about until the computer is rebooted and > will be deleted with other temporary files either on shutdown or on > restart. This is the same thing that happens to other files in the > temporary file folder.
Meaning that on a persistent temp storage the files will stay forever (or until a manually deleted). Then again, on systems such as windows where temp files are never deleted this is to be expected.