Re: [sqlite] concurrency differences between in-memory and on disk?

2009-06-30 Thread Igor Tandetnik
pierr wrote: > So, for "A single connection shared by multiple threads" case, is the > statement "there's a > many-readers-single-writer lock at the database level" still ture? Well, the lock is still there, but since there are no other connections, there's noone to be locked out by it. The

Re: [sqlite] concurrency differences between in-memory and on disk?

2009-06-29 Thread pierr
Igor Tandetnik wrote: > > Daniel Watrous wrote: >> I've developed an application that has very high concurrency. In my >> initial testing we used SQLite 3 from python, but we experienced too >> many locks and the database always fell behind. > > What precisely is the nature of the

Re: [sqlite] concurrency differences between in-memory and on disk?

2009-06-25 Thread Igor Tandetnik
Daniel Watrous wrote: > I've developed an application that has very high concurrency. In my > initial testing we used SQLite 3 from python, but we experienced too > many locks and the database always fell behind. What precisely is the nature of the concurrency? Are you opening multiple