[EMAIL PROTECTED] wrote:
The problem is, not many network filesystems work correctly.
Hi All,
If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue on older implementations of NFS where the file locking does not work correctly. I believe that SMB (windows shares and Samba) do work correctly. I also seem to remember someone saying that current versions of NFS work correctly. It seems like overkill to say SQLite won't work an all network file systems, when in fact it will work on some, perhaps even most.
I appreciate that there are still network latency issues that will impact performance, but that is a separate issue. Many users could accept the lower performance as long as they don't have to worry about corruption.
I'm sure someone knows which versions of NFS have working file locking, at least under Linux. Perhaps we can collect this information about network file systems that are known to work and those that are known to have problems and post them on the wiki. Right now this issue seems to be handled more as folklore than science.
So, what works and what doesn't? Let me know. Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------