The short answer is that you can not (as far as I'm aware, anyway) turn of journal files, though it's a common question and I'm sure you can find a lot of information about it by searching the archives.
TEMP_STORE controls where "truly" temp files (e.g. those needed for sorting, and I believe for tables declared as temporary) are stored. Journal files are not really temporary - they need to persist if the process should die in order for recovery to be performed. They also need to be stored in a predictable location, again so that changes can be consistently recovered in the case of a crash, so they are always stored in the same directory as the database itself. Thus TEMP_STORE has no impact on their creation or location. -Tom > -----Original Message----- > From: Dave Gierok [mailto:[EMAIL PROTECTED] > Sent: Monday, January 15, 2007 11:23 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Is there a way to turn off -journal files? > > I'm building the Sqlite lib using the preprocessor definition > TEMP_STORE=3, but I still notice that temporary '-journal' > files are being created/deleted when running queries that > will modify the DB. I thought that the TEMP_STORE=3 was > supposed to disable these temporary files that get created. > > How can I build/use Sqlite such that these temporary files do > not get created? I am running on Xbox360 and perf/storage > are critical because the DB can be stored to a memory card > (not much storage). > > Thanks, > Dave Gierok > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------