Many thanks to all of you !
I got the answers I expected.
Best regards,
Thomas
John Stanton wrote:
Think about it. A transaction does not affect SELECts, it only defers
the processing of the journal until there is a COMMIT.
According to your version of Sqlite you may get some benefit from
Think about it. A transaction does not affect SELECts, it only defers
the processing of the journal until there is a COMMIT.
According to your version of Sqlite you may get some benefit from
SELECTs within a transaction by retaining the cache.
Ken wrote:
Thomas, if i understand you correctl
Thomas DILIGENT <[EMAIL PROTECTED]> wrote: Hi Ken,
Ken wrote:
> Thomas, if i understand you correctly:
>
> 1. Place the writing of multiple rows of data inside a transaction.
> 2. Querry performance will not be affected by the transaction.
>
> So, If you have multiple rows and are doing somethin
Hi Ken,
Ken wrote:
Thomas, if i understand you correctly:
1. Place the writing of multiple rows of data inside a transaction.
2. Querry performance will not be affected by the transaction.
So, If you have multiple rows and are doing something like the following:
1. Begin Transaction
2
Thomas, if i understand you correctly:
1. Place the writing of multiple rows of data inside a transaction.
2. Querry performance will not be affected by the transaction.
So, If you have multiple rows and are doing something like the following:
1. Begin Transaction
2. Read data from some
Igor Tandetnik wrote:
Thomas DILIGENT <[EMAIL PROTECTED]> wrote:
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 yo
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 (
7 matches
Mail list logo
