On Mon, Jun 30, 2008 at 6:41 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > The default TEMP_STORE is 1, not 0. The default "PRAGMA temp_store" > is 0. TEMP_STORE=1 means that temporary storage defaults to a file > but can be overridden by the temp_store pragma. Alright, cool.
> Temporary storage is never fsync-ed. For that matter, temporary files > are always delete-on-close. So in an OS with a good disk cache, > little or no real disk I/O ever actually occurs on temp files. > Instead, all the data just gets moved in and out of cache blocks in > the kernel. This normally works better than storing the temp data in > memory since after the temp data is deleted, the disk cache block can > be reused by other processes. But writes to the disk can still hurt us with ext3 (and similar file systems) once we call fsync on anything else. We are trying to minimize the number of writes to alleviate this problem. Cheers, Shawn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users