Re: [sqlite] Behavior of SELECT queries during transaction

2007-10-17 Thread drh
Thomas DILIGENT <[EMAIL PROTECTED]> wrote: > > That's it. This is what I want to do. > From this point, I have the following questions : > 1) Will this increase speed compared to a basic solution where I would > use autocommit mode ? (in other words, is it worthy implementing such a > solution

[sqlite] Behavior of SELECT queries during transaction

2007-10-17 Thread Thomas DILIGENT
Hi all ! I would like to know what is the behavior of sqlite when performing a SELECT query during a transaction ? For example : CREATE TABLE thebeatles (_ID INTEGER PRIMARY KEY, name TEXT); BEGIN TRANSACTION; INSERT INTO thebeatles (name) VALUES ('john'); INSERT INTO thebeatles (name) VAL