[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-03 Thread Massimo Di Pierro
I do not know. I do not think it was a corrupt system but if the problem comes back let us know. On Mar 3, 1:09 am, Markus Schmitz wrote: > Hi Massimo and everybody else, > > sorry for my late reply. I was out for two days presenting a prototype > based on web2py on a conference and just came bac

[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-02 Thread Markus Schmitz
Hi Massimo and everybody else, sorry for my late reply. I was out for two days presenting a prototype based on web2py on a conference and just came back to the office. As a quick feedback: Attendees were really impressed and excited about, what they saw. Now back to my problem: I am a bit embarr

[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-01 Thread Massimo Di Pierro
Try add session._unlock(request) at the top of the controller. Does it still lock? On Mar 1, 12:55 am, Markus Schmitz 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 dat

[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-01 Thread cjrh
On Mar 1, 8:55 am, Markus Schmitz wrote: > 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 lon

Re: [web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-01 Thread Jonathan Lundell
On Mar 1, 2011, at 6:23 AM, Anthony wrote: > On Tuesday, March 1, 2011 8:11:01 AM UTC-5, KMax wrote: > SQLite is not good solution for concurent users access. > http://sqlite.org/faq.html#q5 > > From that FAQ, it doesn't sound like SQLite should be locking out other > requests for so long (only

[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-01 Thread Anthony
On Tuesday, March 1, 2011 8:11:01 AM UTC-5, KMax wrote: > > SQLite is not good solution for concurent users access. > http://sqlite.org/faq.html#q5 >From that FAQ, it doesn't sound like SQLite should be locking out other requests for so long (only briefly during write operations) -- Markus sa

[web2py] Re: web2py hangs with multiple users due to sqllite

2011-03-01 Thread KMax
SQLite is not good solution for concurent users access. http://sqlite.org/faq.html#q5 On 1 мар, 12:55, Markus Schmitz 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.