Re: [sqlite] WAL mode and Network filesystems

On Fri, Aug 26, 2011 at 4:43 PM, wrote: > Well, my system configuration is such that the RFS is mounted via NFS > server. All the processes that access the DB will be on the same CPU. Just FYI: in my very limited experience, using fcntl()-style locking on NFS can bring

Re: [sqlite] WAL mode and Network filesystems

umar TP > To: General Discussion of SQLite Database > Subject: Re: [sqlite] WAL mode and Network filesystems > Sent: Aug 26, 2011 20:08 > > http://www.sqlite.org/wal.html > > Disadvantage #2: > All processes using a database must be on the same host computer; WAL > does not

Re: [sqlite] WAL mode and Network filesystems

Well, my system configuration is such that the RFS is mounted via NFS server. All the processes that access the DB will be on the same CPU. --Original Message-- From: Pavel Ivanov To: Sreekumar TP To: General Discussion of SQLite Database Subject: Re: [sqlite] WAL mode and Network

Re: [sqlite] WAL mode and Network filesystems

http://www.sqlite.org/wal.html Disadvantage #2: All processes using a database must be on the same host computer; WAL does not work over a network filesystem. So as long as all users of your database are on the same host it seems that WAL will work even if file is on NFS. But then what's the

[sqlite] WAL mode and Network filesystems

I understand that WAL mode of sqlite is not supported over network file systems. Does this mean that if my DB is in a filesystem mounted on a NFS server will also not work in WAL mode? If so what is the bottleneck? Sent from BlackBerry® on Airtel ___