That sounds right. I might not understand what you're doing so it's just a SWAG ;)
On 4/19/05, William Hachfeld <[EMAIL PROTECTED]> wrote: > 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?
