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

Reply via email to