Thanks Richard, According to the source code, it's an experimental feature :
/* The following is VERY experimental */ { "writable_schema", SQLITE_WriteSchema }, { "omit_readlock", SQLITE_NoReadlock }, We have tested today and it does seem to work. The issue occured again. Which version of sqlite should we be running at least for the feature to work for sure ? Should we use PRAGMA omit_readlock=ON; or PRAGMA omit_readlock=1; ? regards On Wed, Nov 19, 2008 at 2:14 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > 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] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- David LEVY {Selenium} Chief Technical Officer - Zlio.com ----------------------------------------------------------------------------- Blog : http://www.davidlevy.org ZlioShop : http://shop.davidlevy.org Music : http://www.davidlevy.org/music/ ----------------------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users