On Sat, 2005-07-30 at 18:18 -0700, Cory Nelson wrote: > something like sql server is likely better for the task. sqlite can > lag quite a bit when it needs to get file locks over the network to > stay atomic.
The point of this thread is that SQLite cannot be _atomic_ over [any] networked filesystem. It isn't a flaw in SQLite, but a reality of dealing with networked filesystems. Some networked filesystems have special options (nfs -osync, but almost nobody uses that) are close enough such that all you lose is _durability_. An extremely rare strictly-serialized networked filesystem (that are oddly quite common on Plan 9) would be safe, but serialized networked filesystems aren't fast. Not by a long shot. [and are you using plan9?] djm: You still haven't told us exactly what you're using.
