On Fri, Aug 20, 2004 at 08:45:06AM -0600, Ara.T.Howard wrote: > On Fri, 20 Aug 2004, Matt Sergeant wrote: > > >As far as linux -> nfs access goes it all depends on the quality of > >the NFS implementation, and the kernel drivers you're using. It's > >not easy to create a stable NFS locking system. We've had lots of > >problems with it. If you can, go with local disk. > > i cannot - the system is a priority queue system where the queue db > is accessed via around 30 nodes. i am wrapping any code that will > grab a write lock with an nfs safe lockfile creation to ensure only
So, why are using embedded SQLite code on each of the 30 nodes to access the single database file over NFS? Isn't your situation EXACTLY what the client-server RDBMS was invented for? Why don't you simply run PostgreSQL (or your own little custom RDBMS using SQLite) on one machine, and have all 30 clients talk to it over the network? -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/
