On Tue, Apr 19, 2005 at 01:07:03PM -0500, Jay Sprenkle wrote: > 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.
And because I used a transaction on the insert, the lock only has to be obtained once, and thus does not significantly affect performance? -- William Hachfeld ([EMAIL PROTECTED], 651-683-3103) SGI Compilers & Tools
