Hello Richard, I am not a SQLITE expert. As I understand WAL it is especially made for transactions? But our application do not have transactions, just normal SQL queries like Select, Insert and Updates.
So does WAL makes sense for that? 2016-01-14 14:20 GMT+01:00 Richard Hipp <drh at sqlite.org>: > On 1/14/16, Werner Kleiner <sqlitetester at gmail.com> wrote: > > Hello > > I have written a small Wep application with PHP (PDO Apache,). This web > app > > uses a sqlite db3 database. Also there is a Windows application which > uses > > the same database file. > > Now we heard one time that there war a problem and in a log file we saw > the > > error code > > "Database is locked" > > My question now is: > > Could this be a problem when Apache or PHP uses same database and also a > > windows application? > > For example if PHP writes to table "users" and windows application reads > > from "users" at same time? > > Set WAL-mode to work around that. https://www.sqlite.org/wal.html > > Also set a busy timeout using "PRAGMA busy_timeout=10000;" or similar > (https://www.sqlite.org/pragma.html#pragma_busy_timeout). > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
