[sqlite] Behavior of SELECT queries during transaction

[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) VALUES ('paul');

SELECT * FROM thebeatles;

INSERT  INTO thebeatles (name) VALUES ('george');
INSERT  INTO thebeatles (name) VALUES ('ringo');
...

COMMIT TRANSATION;

So,
Does sqlite support this kind of sequence (and how ?) or is it wrong ?
What about the performance issue ?

Thanks in advance,
Thomas

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------