Just a thought. If transactions speed up the access, try this: Begin exclusive Select .... Select ... Select ... Commit
Ie use a transaction around READS. This may acquire the lock once, and give you the same performance as inserts. > -----Original Message----- > From: William Hachfeld [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 19, 2005 10:18 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] NFS Query Performance > > On Tue, Apr 19, 2005 at 11:58:11AM -0700, Ted Unangst wrote: > > If you don't need locking, and it sounds like you don't, > just neuter > > the fcntl calls in os_unix.c. In fact, there's a #define > and comment > > for DJGPP that does exactly what you want. > > Hmmm. Thanks for the suggestion, Ted. I think I'll try this > out. If nothing else, this will help confirm whether the > majority of the slowdown is due to NFS locking performance. > > -- William Hachfeld > > >
