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