Thread

How Many Inserts Per Transactions

Trevor Astrope <astrope@e-corp.net> — 2003-08-05T15:59:11Z

I was wondering if anyone found a sweet spot regarding how many inserts to 
do in a single transaction to get the best performance? Is there an 
approximate number where there isn't any more performance to be had or 
performance may drop off?

It's just a general question...I don't have any specific scenario, other
than there are multiple backends doing many inserts.

Thanks,

Trevor