[sqlite] Re: Re: Re: Re: Re: SQLite3 Concurrency

2007-08-26 Thread Igor Tandetnik
John Stanton <[EMAIL PROTECTED]> wrote: More correctly: BEGIN Thread one BEGIN Thread two INSERT Thread one sets reserved lock INSERT Thread two, fails to set reserved lock SELECT Thread two, set shared lock COMMIT on thread one promot

Re: [sqlite] Re: Re: Re: Re: Re: SQLite3 Concurrency

2007-08-27 Thread John Stanton
Igor Tandetnik wrote: John Stanton <[EMAIL PROTECTED]> wrote: More correctly: BEGIN Thread one BEGIN Thread two INSERT Thread one sets reserved lock INSERT Thread two, fails to set reserved lock SELECT Thread two, set shared lock COM