Re: [sqlite] Locking/Concurrency

KUSHAL SHAH wrote: > My scenario: Multiple processes want to access the database. How do I > configure so that I can get as much concurrency w.r.t read > and write. Meaning, have multiple readers and writers. The best concurrency between separate processes (and thus,

Re: [sqlite] Locking/Concurrency

, crash recovery, etc. Correct?   Thanks, Kushal.   From: Igor Tandetnik <itandet...@mvps.org> To: sqlite-users@sqlite.org Sent: Saturday, May 5, 2012 6:02 PM Subject: Re: [sqlite] Locking/Concurrency KUSHAL SHAH <adroi...@yahoo.com> wrote: >

Re: [sqlite] Locking/Concurrency

KUSHAL SHAH wrote: > I am starting simple where I have exe1 having 1 connection and exe2 having > another connection. > Now if both of them open the connections in mutex mode, will the read/write > requests be serialized. It seems you are saying No. I'm not sure what you

Re: [sqlite] Locking/Concurrency

012 11:04 AM Subject: Re: [sqlite] Locking/Concurrency On 5/4/2012 1:52 PM, KUSHAL SHAH wrote: > I am trying to use SQLite in my .NET project. Client APIs are from > System.Data.SqLite. Can you please help with below: > > It seemsthat multiple > threads can actually read simulta

Re: [sqlite] Locking/Concurrency

On 5/4/2012 1:52 PM, KUSHAL SHAH wrote: I am trying to use SQLite in my .NET project. Client APIs are from System.Data.SqLite. Can you please help with below: It seemsthat multiple threads can actually read simultaneously from a sqlite Db. However, I am confused about the write part. Will

[sqlite] Locking/Concurrency

I am trying to use SQLite in my .NET project. Client APIs are from System.Data.SqLite. Can you please help with below:   It seemsthat multiple threads can actually read simultaneously from a sqlite Db. However, I am confused about the write part. Will SQLite manage the write requests or the user