On 6/17/2019 11:35 PM, Simon Slavin wrote:
I suspect that a lot of software is using BEGIN when it should be using BEGIN 
EXCLUSIVE.

A lot of software doesn't have persistent, long-lived reader transactions. If 
your readers come in, get their data, and quickly get out, then a writer has 
sufficient opportunity to squeeze through, with a simple timeout. See also: 
sqlite3_busy_timeout ( https://www.sqlite.org/c3ref/busy_timeout.html ), PRAGMA 
busy_timeout ( https://www.sqlite.org/pragma.html#pragma_busy_timeout )
--
Igor Tandetnik


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to