On 12 Jan 2016, at 7:40am, Gheorghe Marinca <Gheorghe.Marinca at gfi.com> wrote:
> We have used in an older product a version of sqllite from 7-8-9 years ago. I > oserved that (this being used on a server) when doing sql queries the library > seemed to held, be contended on an internal lock (critical section). Do the > newer versions improve on this or for reading there are always cases where > locks could be involved/limit performance/responsivness ? More recent versions introduced another mode ... <https://www.sqlite.org/wal.html> in which any number of queries can take place without locking the database. Only while changes are committed is the database locked. This was introduced in version 3.7.0 which was released on 2010-07-21. The major disadvantages of this mode are that it does not work at all over network connections, and that if you have one transaction involving a very large number of modifications to the database it can (temporarily) use a lot of storage space. Simon.