Re: [sqlite] One connection with 2 statement handle.

ite-users@sqlite.org> Sent: Monday, April 28, 2008 9:31:17 AM Subject: Re: [sqlite] One connection with 2 statement handle. I would like to clarify on this locking. So if I have one connection and mulitiple statements then there is no locks in this cases regardless what are the statement operations

Re: [sqlite] One connection with 2 statement handle.

SQLite Database <sqlite-users@sqlite.org> Sent: Monday, April 28, 2008 8:44:02 AM Subject: Re: [sqlite] One connection with 2 statement handle. Does this mean that if I have one connection and multiple statements operating on a in-memory table within a single thread no statement will lock out anoth

Re: [sqlite] One connection with 2 statement handle.

Does this mean that if I have one connection and multiple statements operating on a in-memory table within a single thread no statement will lock out another? In other words locks will not be used? On Sat, Apr 26, 2008 at 7:40 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > One

Re: [sqlite] One connection with 2 statement handle.

Joanne Pham wrote: > So one connection is used by two multiple statements concurrently one for > insertion and one for selection. Is that ok. > Yes, that's fine. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org