On Feb 3, 2006, at 10:12 AM, Deepak Kaul wrote:
Can you explain the you mean by "I don't know if I would ever trust NFS." I'm not that familiar with its shortcomings. Do you have any other suggesting other than NFS? Is AFP any better?
My misgivings are based on the things I've read on this forum about not being able to completely trust locking on NFS volumes. I would thing AFP would be much safer, assuming you are using a version of SQLite that fixes the locking problem caused by Mac OS X itself.
Here is what the SQLite FAQ has to say about SQLite databases on NFS volumes:
"But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl () file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time."
