On Wed, Aug 10, 2011 at 10:35 PM, Wenbo Zhao <wbz...@travelsky.com> wrote:

> Hi guys,
> I want a readonly connection wait for locked database instead of error
> return immediately.
> The question is equivalence to how to let a reaonly connection have
> busy_handler triggered
> when the database is locked.
> In my practice, the readonly connection will fail when db locked and
> busy_handler does not work.
>
>
If you set "PRAGMA journal_mode=WAL" then readers will never be blocked.



> Thanks.
>
> --
>
> Best Regards,
> ZHAO, Wenbo
>
> =======================
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to