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 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 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 point of putting database file on NFS if all its users will be on the same host? Local drive will work as well (even faster). Pavel On Fri, Aug 26, 2011 at 10:28 AM, <sreekumar...@gmail.com> wrote: > 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 >_______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Sent from BlackBerry® on Airtel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
