On Jan 19, 2011, at 5:35 AM, Richard Hipp wrote: > On Wed, Jan 19, 2011 at 2:52 AM, Dustin Sallings <dus...@spy.net> > wrote: > >> >> Is it possible without violating any assumptions that would >> lead to >> reliability problems to have a DB's WAL exist on a separate >> filesystem? >> > > No. The WAL has to be in the same directory as the original database. > Otherwise, the process that tries to recover from a crash or power > failure > won't know where to find the WAL file. >
Perhaps that could be the default and a pragma could be used to override this default and specify the directory holding the WAL. This could be useful in cases that users want to put the WAL someplace else (like an SSD). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users