SQLite is not good solution for concurent users access. http://sqlite.org/faq.html#q5
On 1 мар, 12:55, Markus Schmitz <[email protected]> wrote: > Hi everybody, > > on my development system I use sqllite, because it allows me to > conveniently backup my database, which contains a good amount of > configuration data. > > In principle and as long as I access the web site alone, this works > fine. But as soon as two users or I myself access the web site with > two different browsers, the second browser hangs, when fetching the > page. > > More or less all my pages write some data to a table for logging > purposes on access, so when the first browser connects, sqllite locks > the DB. When the second browser connects, the DB is still locked, even > though the page of the first request is long delivered. > > This only happens under sqllite, not MySQL etc. Also when I disable > the logging (ie. the write access) it does not happen. > > Any ideas? Do I have to explicitly commit or close the DB connection? > > Thanks > > Markus
