On a system we developed several years ago (non sqlite) we noted that obtaining locks on an NFS mounted file was VERY slow. I *think* it's trying to establish a lock then waiting at least the propagation delay of your network to ensure there was no collision with another process.
Doing anything over a network is not good for performance. On 4/19/05, William Hachfeld <[EMAIL PROTECTED]> wrote: > > Heh everyone! > > Can anyone explain to me why SQLite shows such poor query performance when the > database is located on an NFS-mounted file system? When running with a single > process accessing the database, I'm finding that my insertion rates are > similar > to local disk, but my query performance is much, much, slower. >