Great thanks for the info. Richard. Pete
________________________________ From: Richard Hipp <d...@sqlite.org> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wed, November 24, 2010 3:11:57 PM Subject: Re: [sqlite] WAL for single user database on nfs On Wed, Nov 24, 2010 at 6:01 PM, p r <p_r...@yahoo.com> wrote: > I read the following statement on > http://www.sqlite.org/wal.html#concurrency > > ..This is why the write-ahead log implementation will not work on a network > filesystem... > > I can how nfs would be an issue (due to stale handles) if processes from > different machines were to access the sqlite db but I am thinking of a > single > process at a time (of n such processes on 1 machine) accessing a single > Sqlite > database at a time over nfs - is WAL safe/feasible or not supported in that > mode? > I guess it depends on your NFS implementation. SQLite uses mmap() to get the shared memory it needs. Is mmap() supported on NFS files? Beginning with SQLite version 3.7.4 (due out in about 2 weeks) you can use WAL mode without shared memory by using "PRAGMA locking_mode=EXCLUSIVE". That will be a safer approach. > > Thanks. > > Pete. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
