[sqlite] Size of INSERT and UPDATE in TRANSACTION

[Hannes Ricklefs]

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 TRANSACTIONS of 1000
each?

Thanks,
Hannes