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 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