[sqlite] Sqlite3 lock issue with NFS and read-only queries

2008-11-19 Thread David Levy
e locking the database for *any* query ? Is there a way to tell Sqlite to not lock the database when we know there are only read-only queries ? Thanks ! -- David LEVY {Selenium} Chief Technical Officer - Zlio.com - Blog

Re: [sqlite] Sqlite3 lock issue with NFS and read-only queries

2008-11-19 Thread David Levy
> On Nov 19, 2008, at 5:07 AM, David Levy wrote: > > Is there a way to tell Sqlite to not lock the database when we know > > there > > are only read-only queries ? > > > > > PRAGMA omit_readlock=ON; > > > D. Richard Hipp > [EMAIL PROTECTED] > &

Re: [sqlite] Sqlite3 lock issue with NFS and read-only queries

2008-11-21 Thread David Levy
? Thanks ! On Wed, Nov 19, 2008 at 6:54 PM, David Levy <[EMAIL PROTECTED]> wrote: > Thanks Richard, > > According to the source code, it's an experimental feature : > > /* The following is VERY experimental */ > { "writable_schema", SQLITE_WriteSc