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
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
