Re: [sqlite] READ UNCOMMITTED isolation?

2006-01-31 Thread Christian Smith
On Mon, 30 Jan 2006, Gerhard Häring wrote: >[EMAIL PROTECTED] wrote: >> "Dan Petitt" <[EMAIL PROTECTED]> wrote: >> >>>I think (looking at the source) that it's a pragma, but I don't know when >>>you set it, once when DB is opened, on each write or on each read. >>> >>>You are the third to ask

Re: [sqlite] READ UNCOMMITTED isolation?

2006-01-30 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: "Dan Petitt" <[EMAIL PROTECTED]> wrote: I think (looking at the source) that it's a pragma, but I don't know when you set it, once when DB is opened, on each write or on each read. You are the third to ask (including me), maybe Richard or someone else can through some

Re: [sqlite] READ UNCOMMITTED isolation?

2006-01-30 Thread drh
"Dan Petitt" <[EMAIL PROTECTED]> wrote: > I think (looking at the source) that it's a pragma, but I don't know when > you set it, once when DB is opened, on each write or on each read. > > You are the third to ask (including me), maybe Richard or someone else can > through some light on it for

RE: [sqlite] READ UNCOMMITTED isolation?

2006-01-30 Thread Dan Petitt
DigiGuide TV Guide First Floor Office Suite 17 The Strand Exmouth Devon. EX8 1AF Tel / Fax: 01395 272555 -Original Message- From: Jack Pan [mailto:[EMAIL PROTECTED] On Behalf Of Cecilia Chen Sent: 29 January 2006 15:33 To: sqlite-users@sqlite.org Subject: [sqlite] READ UNCOMMITTED

[sqlite] READ UNCOMMITTED isolation?

2006-01-29 Thread Cecilia Chen
Does anyone know how to use the new READ UNCOMMITTED isolation? It would be great to have this isolation level when one thread reads and another writes. My program doesn't worry too much about read consistency. Thanks, Jack Pan