Thomas DILIGENT <[EMAIL PROTECTED]> wrote:
I would like to know what is the behavior of sqlite when performing a
SELECT query during a transaction ?
The same as outside the transaction.
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 ?)
Yes (easily).
or is it wrong ?
No, it is right.
What about the performance issue ?
What about it?
You need to provide some context. Your questions, standing alone, don't
make much sense, no offence intended. What problem are you trying to
solve, and what specifically are you concerned about?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
