"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 3/2/06, Vishal Kashyap <[EMAIL PROTECTED]> wrote: > > Dear All , > > > > Wanted to know if we can use sqlite database from network drives ? > > It works if your operating system correctly handles locking. > If I remember correctly there are some problems with windows drives, > but NFS works. > Check the documentation section of the web site. > > .
It works on some, but not all, versions of windows. And it works on some, but not all, version of NFS. On those operating systems where network file locking is not implemented correctly the result will be corrupt database files. The performance of SQLite over a network filesystem is consistent to the performance of the network filesystem itself - very slow. SQLite will, in theory, work over a network filesystem. But for the reasons cited above, it is not recommended. That said, I should add that for the reasons cited above, the use of a network filesystem itself is not recommended. But that is a whole other story.... -- D. Richard Hipp <[EMAIL PROTECTED]>
