Re: [sqlite] Size of INSERT and UPDATE in TRANSACTION

It would be the other way around, no? The larger the no of inserts within a Transaction, the better the performance. On 10/27/05, Hannes Ricklefs <[EMAIL PROTECTED]> wrote: > > Hello, > > I was wondering if anyone has any experience with the number of INSERT > UPDATE > statements in one TRANSACTI

Re: [sqlite] Size of INSERT and UPDATE in TRANSACTION

Hello Hannes, I think no, you need not split your transaction. I do millions on insert in one transaction and it works real fast Martin Hannes Ricklefs schrieb: Hello, I was wondering if anyone has any experience with the number of INSERT UPDATE statements in one TRANSACTION. For example I

[sqlite] Size of INSERT and UPDATE in TRANSACTION

Hello, I was wondering if anyone has any experience with the number of INSERT UPDATE statements in one TRANSACTION. For example I have the situation that i have to do around 20.000 INSERTS in one TRANSACTION, so I am wondering if it has any performance improvements if I split these up into smaller